pgsql-server: Some preliminary documentation for composite-type stuff.

Started by Tom Laneabout 22 years ago3 messagescomitters
Jump to latest
#2Alvaro Herrera
alvherre@dcc.uchile.cl
In reply to: Tom Lane (#1)
Re: pgsql-server: Some preliminary documentation for composite-type stuff.

On Mon, Jun 07, 2004 at 01:04:48AM -0300, Tom Lane wrote:

Log Message:
-----------
Some preliminary documentation for composite-type stuff.

*sigh* Hard to keep up with this guy. I'm off a weekend and he's
already modified half the source tree. :-D

Nice work. This is a cool unexpected step forward in functionality.
Thanks.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La conclusi�n que podemos sacar de esos estudios es que
no podemos sacar ninguna conclusi�n de ellos" (Tanenbaum)

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Alvaro Herrera (#2)
Re: pgsql-server: Some preliminary documentation for composite-type stuff.

Alvaro Herrera <alvherre@dcc.uchile.cl> writes:

Nice work. This is a cool unexpected step forward in functionality.

As recently as Thursday I didn't think this would get done for 7.5,
but I wanted to nibble off a few rough edges, and after a while there
weren't any left.

Or almost ... I just noticed that there's no convenient way to assign to
a subfield in UPDATE. You can hack around it with something like
UPDATE mytab SET myfield = ROW(myfield.a, newval, myfield.c)
but my goodness that's painful. AFAICS the SQL99 spec gives license
to write
UPDATE mytab SET myfield.b = newval
and I think I will look into making that happen tomorrow. We already
have a solution in place for assigning to an array element, and this
doesn't seem much different.

regards, tom lane