Re: Subselect query for a multi table insert single query

From: "Norman Khine" <norman(at)khine(dot)net>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Pgsql-Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Subselect query for a multi table insert single query
Date: 2002-09-23 06:23:15
Message-ID: 007001c262c9$b3db2fb0$0100a8c0@alpha
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Many thanks

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

> "Norman Khine" <norman(at)khine(dot)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
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message norman 2002-09-23 09:56:31 Re: Subselect query for a multi table insert single query
Previous Message Tom Lane 2002-09-23 04:18:54 Re: Subselect query for a multi table insert single query