From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | Karl Denninger <karl(at)denninger(dot)net> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Ok, what am I doing wrong here? |
Date: | 2004-02-17 16:29:06 |
Message-ID: | 20040217082231.C41055@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
sszabo(at)bigpanda(dot)com
On Tue, 17 Feb 2004, Karl Denninger wrote:
> I want to insert values from one table into another, and add some "default"
> values (that are not defaults on the table different reasons - that is, this
> is maintenance function and in normal operation there would be "real" values
> there - and null is valid)
>
> So, I want to do, for example, the following:
>
> insert into table (id, time, type) values (select id, now(), '1' from secondtable);
>
> Postgres's command line pukes on this, complaining that "select" is invalid
> inside the values part of the definition.
>
> SQL's language specification says otherwise, as does "\h insert" from the
> command line.
I think what you want is
insert into table (id, time, type) select id, now(), '1' from secondtable;
The choices allowed right now are default values, something that is
basically a row constructor with values [*] or a query.
[*] - The full spec allows a list of row constructors but we don't
currently.
From | Date | Subject | |
---|---|---|---|
Next Message | Tomasz Myrta | 2004-02-17 16:34:46 | Re: Ok, what am I doing wrong here? |
Previous Message | Marc G. Fournier | 2004-02-17 16:20:58 | Re: Ok, what am I doing wrong here? |