Re: PL/pgSQL parameter passing bug?

From: Doug McNaught <doug(at)wireboard(dot)com>
To: Ed Loehr <ed(at)accuros(dot)com>
Cc: pggeneral <pgsql-general(at)postgresql(dot)org>
Subject: Re: PL/pgSQL parameter passing bug?
Date: 2001-03-30 22:52:58
Message-ID: m38zlmoomt.fsf@belphigor.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ed Loehr <ed(at)accuros(dot)com> writes:

> I'm seeing actual parameters impacted by the value of another actual
> parameter in an unexpected manner. Example test case and example run
> included below. This is occuring on 7.0.3 on Redhat. Can anyone confirm
> or educate me?

This is a known problem with 7.0.x that is fixed in the upcoming 7.1
release. If you pass one NULL parameter to a function, they all
become NULL.

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Serodio 2001-03-30 23:14:12 Re: Locale and LIKE matching
Previous Message Jim Mercer 2001-03-30 22:50:32 pg_hba.conf and crypt/password