From: | George Young <gry(at)ll(dot)mit(dot)edu> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | class as a table column? |
Date: | 1999-07-09 19:31:12 |
Message-ID: | 199907091930.PAA01596@ll.mit.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
[libpq++ with gcc egcs-2.91.66 (egcs-1.1.2 release) on RH linux 5.1
with Postgres 6.5.]
I've seen in the manual that one can create a table with a class/table
as one of the columns, e.g.:
--set (complex) attribute may be of the same type as the
--relation being defined (as here) or of a different complex
--type. The type must exist in the "pg_type" catalog or be
--the one currently being defined.
--
create table newemp (name text, manager newemp)
and I have been able to do this in psql.
But what does this really mean? And how does one insert or extract
data from such a column? And what is it good for? It seems like
maybe a powerful facility, but I really don't understand it.
Is this sort-of the same as inheriting from that class?
Does anyone have examples of its use?
Thanks,
George
George Young, Rm. L-204 gry(at)ll(dot)mit(dot)edu
MIT Lincoln Laboratory
244 Wood St.
Lexington, Massachusetts 02420-9108 (781) 981-2756
From | Date | Subject | |
---|---|---|---|
Next Message | George Young | 1999-07-09 20:37:00 | class as a table column? |
Previous Message | Eid, Bilal | 1999-07-09 17:27:18 | RE: [SQL] offtopic: odbc C frontend for linux? |