Received: from trantor.eads-dsn.com (trantor.eads-dsn.com [194.117.220.38]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f339dRK40995 for ; Tue, 3 Apr 2001 05:39:35 -0400 (EDT) (envelope-from cyril.picard@eads-dsn.com) Received: by trantor.eads-dsn.com; id LAA23655; Tue, 3 Apr 2001 11:39:17 +0200 (MET DST) Received: from unknown(172.29.64.4) by trantor.eads-dsn.com via smap (4.5) id xma023645; Tue, 3 Apr 2001 11:38:55 +0200 Received: from edsnsrvbda01.edsn.com (edsnsrvbda01 [172.29.64.12]) by hermes.eads-dsn.com (8.11.0/8.11.0) with ESMTP id f339PIG08145 for ; Tue, 3 Apr 2001 11:25:18 +0200 Received: from pmrmnc.edsn.com ([131.129.4.201]) by edsnsrvbda01.edsn.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id G30X6VJG; Tue, 3 Apr 2001 11:36:12 +0200 Received: from pmrpass.edsn.com (PMRPASS [192.168.4.3]) by pmrmnc.edsn.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id GRF3F5SY; Tue, 3 Apr 2001 11:34:48 +0200 Received: from pmrmsg.edsn.com ([130.10.50.9]) by pmrpass.edsn.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id G3020YH4; Tue, 3 Apr 2001 11:35:48 +0200 Received: by pmrmsg.edsn.com with Internet Mail Service (5.5.2650.21) id ; Tue, 3 Apr 2001 11:39:30 +0200 Message-ID: From: "Picard, Cyril" To: pgsql-sql@postgresql.org Subject: RE: passing null parameter to plpgsq functions Date: Tue, 3 Apr 2001 11:39:30 +0200 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f339dtK41010 X-Archive-Number: 200104/25 X-Sequence-Number: 2364 Thank you ! I planned to use the 7.1 to get the outer join capability. Is the 7.1 stable ? > -----Message d'origine----- > De: Richard Huxton [SMTP:dev@archonet.com] > Date: mardi 3 avril 2001 10:06 > À: Picard, Cyril; pgsql-sql@postgresql.org > Objet: Re: [SQL] passing null parameter to plpgsq functions > > From: "Picard, Cyril" > > > Hello > > I wrote a plpgsql function with few parameters ; when I call the > function, > > some of the parameters can be null. > > In this case, all the parameters are considered as null in the > function's > > body ! is it a feature ? how can I work around this ? > > It's a feature in versions before 7.1 (or possibly 7.0.x) you can still > get > that behaviour in 7.1 by asking for strict null handling on a specific > function. > > The only remedy AFAIK is to upgrade. > > - Richard Huxton > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html