Message-ID: <20040217100250.A65968@Denninger.Net>
Date: Tue, 17 Feb 2004 10:02:50 -0600
From: Karl Denninger <karl@denninger.net>
To: pgsql-sql@postgresql.org
Subject: Ok, what am I doing wrong here?
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Karl's Sushi and Packet Smashers

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?

--
-- 
Karl Denninger (karl@denninger.net) Internet Consultant & Kids Rights Activist
http://www.denninger.net	Tired of spam at your company?  LOOK HERE!
http://childrens-justice.org	Working for family and children's rights
http://diversunion.org		LOG IN AND GET YOUR TANK STICKERS TODAY!
http://scubaforum.org		Come talk about DIVING!