Re: Subselect query for a multi table insert single query - Mailing list pgsql-novice

From Norman Khine
Subject Re: Subselect query for a multi table insert single query
Date
Msg-id 007001c262c9$b3db2fb0$0100a8c0@alpha
Whole thread Raw
In response to Re: Subselect query for a multi table insert single query  ("Norman Khine" <norman@khine.net>)
List pgsql-novice
Many thanks

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Norman Khine" <norman@khine.net>
Cc: "Pgsql-Novice" <pgsql-novice@postgresql.org>
Sent: Monday, September 23, 2002 5:18 AM
Subject: Re: [NOVICE] Subselect query for a multi table insert single query


> "Norman Khine" <norman@khine.net> writes:
> >  What should be the correct syntax for embedding this.
>
> This would work fine:
>
> INSERT INTO table VALUES (foo, bar, baz, currval('seq'), ...);
>
> The elements of an INSERT/VALUES list are expressions, not
> necessarily literal constants.
>
> regards, tom lane
>


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Subselect query for a multi table insert single query
Next
From: norman@khine.net
Date:
Subject: Re: Subselect query for a multi table insert single query