Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 20F514761B4 for ; Tue, 4 Jun 2002 18:26:31 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id B2CDD4759D7 for ; Tue, 4 Jun 2002 18:18:17 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id CC884D5F7; Tue, 4 Jun 2002 15:18:19 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id C23E55C02; Tue, 4 Jun 2002 15:18:19 -0700 (PDT) Date: Tue, 4 Jun 2002 15:18:19 -0700 (PDT) From: Stephan Szabo To: Rui Pacheco Cc: Subject: Re: Some problems with (my?) PlSQL In-Reply-To: <034601c20c13$755ce790$1601a8c0@devdomain.com> Message-ID: <20020604151623.Y6858-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200206/33 X-Sequence-Number: 7998 On Tue, 4 Jun 2002, Rui Pacheco wrote: > BEGIN > > UPDATE TS_USERS SET > LOGIN = strLogin, EMAIL = strEmail, TITLE = strTitle, FIRST_NAME = > strFirstName, > LAST_NAME = strLastName, DATE_CREATION = TIMESTAMP (strDateCreation), > DATE_LAST_ACCESS = TIMESTAMP (strDateLastAccess), ACC_LOCKED = > strAccLocked, > ACC_DISABLED = strAccDisabled, PASSWD_CHALLENGE = strPasswdChallenge, > PASSWD_CHALLENGE_RESPONSE = strPasswdChallengeResponse > WHERE ID = intId; > > RETURN 1; > END; > ' LANGUAGE 'plpgsql'; > ------- > > While not reaching the limit of arguments, this function, when called, gives > me this error: > > 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.