From: | elein <elein(at)norcov(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org, elein(at)norcov(dot)com |
Subject: | Re: PostgreSQL 7.3: help on new CREATE TYPE |
Date: | 2002-09-24 02:10:48 |
Message-ID: | 200209240210.g8O2AZI5620942@pimout2-ext.prodigy.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Illustra did a very nice job with "composite types" which
correspond to these record types. The composite types
were able to be used as a column type as jerome describes.
The subcolumns were accessed with dots. This gave us
schema.table.column.attribute
where of course attribute could itself be a composite type....
Well, ok, it had some drawbacks, too.
If we ever are serious about implementing this I would help
with discussing and/or writing the specs. I can put together a nice spec.
When I get a break on my book project, I might just write it up anyway.
elein
elein(at)norcov(dot)com
PS: Everyone please forgive me for reading list mail late and out of order...
I am in awe of anyone keeping up.
On Tuesday 17 September 2002 07:22, Tom Lane wrote:
> "Jerome Chochon" <jerome(dot)chochon(at)ensma(dot)fr> writes:
> > Can I use this new type like other user-type ?
> > CREATE TABLE person (his_name VARCHAR, his_adress adress);
> > ...where adress is CREATE TYPE adress AS (number int, street text,
> > country VARCHAR);
>
> Not at the moment, though that might be an interesting direction to
> pursue in future releases. At present, the only thing such a type is
> useful for is to define the argument or result type of a function that
> takes or returns records.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2002-09-24 02:11:48 | Re: [SQL] Monitoring a Query |
Previous Message | Bruce Momjian | 2002-09-24 02:01:06 | Re: [GENERAL] CURRENT_TIMESTAMP |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2002-09-24 02:11:48 | Re: [SQL] Monitoring a Query |
Previous Message | Bruce Momjian | 2002-09-24 02:01:06 | Re: [GENERAL] CURRENT_TIMESTAMP |