| From: | Loïc TREGOUËT <loic(at)cri74(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | How tu put/read a composite type in a table? |
| Date: | 2000-04-28 15:52:15 |
| Message-ID: | 3909B3AF.C79CFB2D@cri74.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thanks to those who will have the force read my mail until the end ...
I 've search for a long time (one week) how to work with composite type.
create table compositeDef ( i int4 , t text ) ;
create table myTable ( j int4 , c composite);
I'm right (isn't it?) because when i create a naw table , a new type is
created automatically ?
But i don't know how i can put (and read) a object of type
"compositeDef" into the table "myTable" ?
Maybe some of you , are thinking it's more easier to create the table
myTable with :
create table myTable (j int4 ) inherits (compositeDef) ;
but it's not the solution i need.
PLEASE HELP !!! : i'm french and i'm a newbie : nothing which is good
for me !!!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Travis Bauer | 2000-04-28 16:38:57 | problem with nested views |
| Previous Message | Marc Tardif | 2000-04-28 15:45:47 | Re: advice on indexing email |