Re: Some problems with (my?) PlSQL

From: "Rui Pacheco" <rep(at)devdomain(dot)com>
To: "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Some problems with (my?) PlSQL
Date: 2002-06-04 23:26:02
Message-ID: 036a01c20c1f$3187d460$1601a8c0@devdomain.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> > Query error [SELECT devUsersUpdate ('1', 'root', '',
'root(at)somehost(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian - CVS 2002-06-05 04:01:27 pgsql/doc/TODO.detail mmap
Previous Message Tom Haddon 2002-06-04 23:04:03 alter column - NOT NULL