Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 6DB199FA5CE for ; Wed, 8 Aug 2007 02:40:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 52923-07 for ; Wed, 8 Aug 2007 02:40:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mtao03.charter.net (mtao03.charter.net [209.225.8.188]) by postgresql.org (Postfix) with ESMTP id CFD689FBAFE for ; Wed, 8 Aug 2007 02:40:27 -0300 (ADT) Received: from aa04.charter.net ([10.20.200.156]) by mtao03.charter.net (InterMail vM.7.08.02.02 201-2186-121-104-20070414) with ESMTP id <20070808054022.OFW15538.mtao03.charter.net@aa04.charter.net>; Wed, 8 Aug 2007 01:40:22 -0400 Received: from [10.0.1.3] (really [66.188.165.91]) by aa04.charter.net with ESMTP id <20070808054022.GQMG1254.aa04.charter.net@[10.0.1.3]>; Wed, 8 Aug 2007 01:40:22 -0400 In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <113AAF3D-9E86-4A69-8CDB-5A224C8FC3BE@seespotcode.net> Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: populate value of column Date: Wed, 8 Aug 2007 00:40:20 -0500 To: novice X-Mailer: Apple Mail (2.752.2) X-Chzlrs: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/46 X-Sequence-Number: 28984 On Aug 8, 2007, at 0:30 , novice wrote: > CREATE TABLE meter > ( > meter_id integer NOT NULL, > area_no integer NOT NULL, > CONSTRAINT meter_pkey PRIMARY KEY (meter_id) > ) ; > > INSERT INTO meter(meter_id, no_of_bays) VALUES (1001, 4); > INSERT INTO meter(meter_id, no_of_bays) VALUES (1012, 6); Your insert columns don't match your table. > How can I generate the following result? > > meter_id | bay > ----------+------------ > 1001 | 01 Your column headers don't match your table definition *or* your insert statements. I'm not sure what you're trying to do. Can you explain the result you want? (And in the future, please post actual DDL and statements.) Michael Glaesemann grzm seespotcode net