Обсуждение: pgsql-server: Some preliminary documentation for composite-type stuff.

Поиск
Список
Период
Сортировка

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

От
tgl@svr1.postgresql.org (Tom Lane)
Дата:

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

От
Alvaro Herrera
Дата:
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)


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

От
Tom Lane
Дата:
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