Skip site navigation (1) Skip section navigation (2)

Re: Better support for whole-row operations and composite types

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Better support for whole-row operations and composite types
Date: 2004-03-30 18:00:50
Message-ID: 200403301000.51098.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom,

> We have a number of issues revolving around the fact that composite types
> (row types) aren't first-class objects.  I think it's past time to fix
> that.  Here are some notes about doing it.  I am not sure all these ideas
> are fully-baked ... comments appreciated.

I'll want to add to the documentation on composite types, then.   We'll need a 
stern warning to users not to abuse them.  Easily done, I think.

Composite types are frequently abused by OO and Windows programmers to break 
the relational model.    I used to be an MSDN member (thank you, I've 
recovered) and frequently ran into, on the mailing list, users getting 
themselves into some unresolvable mess becuase they'd used composite types in 
SQL server to combine several rows ... or even effectively an entire child 
table ... into one field.

Othewise, looks good to me.   I don't think I'm qualified to second-guess you 
on the implementation.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-hackers by date

Next:From: elrikDate: 2004-03-30 18:05:02
Subject: what do postgresql with view ?
Previous:From: kkim3Date: 2004-03-30 17:58:31
Subject: Transaction question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group