X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D8BC0D1DF93 for ; Tue, 17 Feb 2004 16:58:07 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 35173-08 for ; Tue, 17 Feb 2004 12:58:01 -0400 (AST) Received: from FS.Denninger.Net (user66.net1062.fl.sprint-hsd.net [69.34.227.66]) by svr1.postgresql.org (Postfix) with ESMTP id CA7DCD1DF85 for ; Tue, 17 Feb 2004 12:58:00 -0400 (AST) Received: from fs.denninger.net (localhost [127.0.0.1]) by FS.Denninger.Net (8.12.10/8.12.8) with SMTP id i1HGw0sI066717 for ; Tue, 17 Feb 2004 10:58:00 -0600 (CST) (envelope-from karl@FS.Denninger.Net) Received: from fs.denninger.net [127.0.0.1] by Spamblock-sys; Tue Feb 17 10:58:00 2004 Received: (from karl@localhost) by FS.Denninger.Net (8.12.10/8.12.8/Submit) id i1HGw0ZO066715; Tue, 17 Feb 2004 10:58:00 -0600 (CST) Message-ID: <20040217105800.A66571@Denninger.Net> Date: Tue, 17 Feb 2004 10:58:00 -0600 From: Karl Denninger To: Stephan Szabo Cc: pgsql-sql@postgresql.org Subject: Re: Ok, what am I doing wrong here? References: <20040217100250.A65968@Denninger.Net> <20040217082231.C41055@megazone.bigpanda.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.93.2i In-Reply-To: <20040217082231.C41055@megazone.bigpanda.com>; from Stephan Szabo on Tue, Feb 17, 2004 at 08:29:06AM -0800 Organization: Karl's Sushi and Packet Smashers X-Die-Spammers: Spammers cheerfully broiled for supper and served with ketchup! X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/214 X-Sequence-Number: 16904 Thanks... -- -- 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! On Tue, Feb 17, 2004 at 08:29:06AM -0800, Stephan Szabo wrote: > sszabo@bigpanda.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. > > > > %SPAMBLOCK-SYS: Matched [@postgresql.org], message ok