Forwarded mail....

From: Konstantinos Vassiliadis <vassilik(at)p05(dot)cs(dot)man(dot)ac(dot)uk>
To: pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Forwarded mail....
Date: 1998-07-20 12:05:50
Message-ID: Pine.LNX.3.95.980720130424.22245B-100000@p05.cs.man.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi
I sent this message to the SQL-related mailing but nobody has replied for
three days now. Can anyone help?
Kostas

---------- Forwarded message ----------
Date: Sat, 18 Jul 1998 14:14:28 +0100 (BST)
From: Konstantinos Vassiliadis <vassilik(at)p03(dot)cs(dot)man(dot)ac(dot)uk>
To: pgsql-sql(at)postgresql(dot)org

Hello,
I have the following two tables
create table protein
(structures setof pdb);

create table pdb
(identifier text);

That is, I express the fact that a protein has many pdb's as a nested
relation. I then try to insert values into a protein

insert into protein values (pdb('..'),pdb('..'));

but it does not work. How can I insert values?
Does Postgres support this feature?

Thanks
Kostas Vassiliadis

NB I also tried
create table temp
(numbers setof int);

and tried to insert but couldn't.

Browse pgsql-general by date

  From Date Subject
Next Message Aleksey Dashevsky 1998-07-20 14:20:06 Removing user-defined types & functions
Previous Message Konstantinos Vassiliadis 1998-07-20 12:04:07 Inserting values into set attributes (fwd)