Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 6468B4759A3 for ; Tue, 4 Jun 2002 19:26:59 -0400 (EDT) Received: from kenny.devdomain.com (a213-22-140-120.netcabo.pt [213.22.140.120]) by postgresql.org (Postfix) with ESMTP id 1DB25475981 for ; Tue, 4 Jun 2002 19:26:53 -0400 (EDT) Received: from voodoo (unknown [192.168.10.254]) by kenny.devdomain.com (Postfix) with SMTP id 31CB6403C; Wed, 5 Jun 2002 00:33:26 +0100 (WEST) Message-ID: <036a01c20c1f$3187d460$1601a8c0@devdomain.com> From: "Rui Pacheco" To: "Stephan Szabo" Cc: References: <20020604151623.Y6858-100000@megazone23.bigpanda.com> Subject: Re: Some problems with (my?) PlSQL Date: Wed, 5 Jun 2002 00:26:02 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200206/35 X-Sequence-Number: 8000 > > Query error [SELECT devUsersUpdate ('1', 'root', '', 'root@somehost.com', > > '', 'Super', 'User', '0001-01-01', '0001-01-01', 'N', 'N', '', '')]: ERROR: > > parser: parse error at or near "$6" > > Wierd that it would say $6. You might be getting bitten by the changes to > timestamp. Maybe using "timestamp"(strDateCreation) and > "timestamp"(strDateLastAccess) would make it work. That's it! Thanks a lot for your tip! :) Rui