Re: PL/pgSQL functions: NULL parameter trouble

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: "Pryadkin, Vyacheslav" <VPryadkin(at)SECTORBASE(dot)COM>
Cc: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: PL/pgSQL functions: NULL parameter trouble
Date: 2000-10-28 06:48:20
Message-ID: 39FA76B4.6AFE7E9E@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> PL/pgSQL functions:
> if one of parameters is NULL, all another parameters
> take NULL values regardless of transmitted NOT NULL values.

This was true in previous releases, but v7.1 will have this behavior
changed to allow passing a mix of NULL and non-NULL values to
subroutines.

- Thomas

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message alain franciosa 2000-10-29 10:05:06 linux+doQuery infinite loop
Previous Message Philip Warner 2000-10-28 05:48:59 Re: MySQL/PostgreSQL discrepancy