Re: Some problems with (my?) PlSQL - Mailing list pgsql-sql

From Rui Pacheco
Subject Re: Some problems with (my?) PlSQL
Date
Msg-id 036a01c20c1f$3187d460$1601a8c0@devdomain.com
Whole thread Raw
In response to Re: Some problems with (my?) PlSQL  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
> > 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



pgsql-sql by date:

Previous
From: "Tom Haddon"
Date:
Subject: alter column - NOT NULL
Next
From: "Sandeep Chibber"
Date:
Subject: Postgres Function Proble