Thread

1. PL/pgSQL functions: NULL parameter trouble

   Pryadkin, Vyacheslav <vpryadkin@sectorbase.com> — 2000-10-27T17:41:27Z

   PL/pgSQL functions:
   if one of parameters is NULL, all another parameters
   take NULL values regardless of transmitted NOT NULL values.
   ----------------------
   Vyacheslav Pryadkin
   Software Engineer
   SECTORBASE.com
   568 Howard Str, First Floor
   SF, CA, 94105
   (415)365-8234
   (415)760-0267 (cell)
   
   

2. Re: PL/pgSQL functions: NULL parameter trouble

   Thomas Lockhart <lockhart@alumni.caltech.edu> — 2000-10-28T06:48:20Z

   > 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