X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A60CD476AC6 for ; Thu, 15 May 2003 14:57:34 -0400 (EDT) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with ESMTP id 73063-08 for ; Thu, 15 May 2003 14:57:02 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 6AC34476B1E for ; Thu, 15 May 2003 13:27:00 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 4C242D61E; Thu, 15 May 2003 10:27:00 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 41B9F5C04; Thu, 15 May 2003 10:27:00 -0700 (PDT) Date: Thu, 15 May 2003 10:27:00 -0700 (PDT) From: Stephan Szabo To: eric Cc: , "Marc G. Fournier" , Subject: Re: Inquiry From Form [pgsql] In-Reply-To: <20030515020456.944AA184DED1@hub.org> Message-ID: <20030515102625.Q62782-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/333 X-Sequence-Number: 13498 On Wed, 14 May 2003, eric wrote: > in access i can put the content of a field \'date()\'. how could i do > the same in postgres? when i set \'date()\', i\'ve got the error > message \'zero-length defined identifier\' It would be helpful if you gave more information like the specific table schema and insert/update that you are doing.