From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
---|---|
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:20:58 |
Message-ID: | 20040217122000.X94474@ganymede.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
>
> The query stand-alone returns a table with values that are valid for the
> table I wish to insert into.
>
> Where's my brain-fade on this?
INSERT INTO table (id, time, type) SELECT id, now(), '1' FROM secondtable;
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2004-02-17 16:29:06 | Re: Ok, what am I doing wrong here? |
Previous Message | Karl Denninger | 2004-02-17 16:02:50 | Ok, what am I doing wrong here? |