Re: Question #4 about PL/PGSQL

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Question #4 about PL/PGSQL
Date: 2001-01-16 05:10:51
Message-ID: web-1177584@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom,

> Not only varchar --- any other parameters, period. And
> not only that,
> but the result is taken as NULL no matter what you try to
> return.

Not quite. I tried the following:

Parameters: $1=integer, $2=NULL, $3=varchar

And I had the function test for nulls. It read the first
parameter, but not $3. It did return the string telling me
it had found nulls, however.

> This is a longstanding deficiency that is fixed by the
> new function
> manager in 7.1.

Damn! When is the "holy grail" of PostgreSQL going to be
stable enough to use? Beta3 still has a "not advisable for
production" warning, and I'm being tied up in knots by the
number of things I need in 7.1.

Would it help if I sent more money? :-)

-Josh

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Lockhart 2001-01-16 05:12:29 Re: outer join in PostgreSql
Previous Message Tom Lane 2001-01-16 04:58:51 Re: Question #4 about PL/PGSQL