Postgres Pro
Downloads
Home   >   mailing lists

Re: Antw: plpgsql function gets wierd with Null parameters - Mailing list pgsql-sql

From Tom Lane
Subject Re: Antw: plpgsql function gets wierd with Null parameters
Date
Msg-id 18923.962633811@sss.pgh.pa.us
Whole thread Raw
In response to Antw: plpgsql function gets wierd with Null parameters  ("Gerhard Dieringer" <DieringG@eba-haus.de>)
List pgsql-sql
Tree view 
"Gerhard Dieringer" <DieringG@eba-haus.de> writes:
> It's a known bug of plpgsql that if one arg is NULL, all other args
> are also assumed to be NULL.  I think (hope) this will be fixed in a
> future version.

7.1.  It is already fixed in current development sources.

BTW it's not actually plpgsql's fault, but that of the function-call
interface.  The problem appears no matter what programming language
you write the function in.
        regards, tom lane

pgsql-sql by date:

Previous
From: emils@dot.lv
Date:
Subject: ...
Next
From: John
Date:
Subject: Need Help With Dates.