Re: test strange behavior - Mailing list pgsql-novice

From Jean-Yves F. Barbier
Subject Re: test strange behavior
Date
Msg-id 20111107011646.2fe7fbd2@anubis.defcon1
Whole thread Raw
In response to Re: test strange behavior  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On Sun, 06 Nov 2011 18:50:29 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> [ Please keep the list cc'd. ]

Yeah I know: all other MLs I'm subscribed use the ML e-mail address
as the To: field, yours use the subscriber; so I have to hit
ctrl-shit-r instead of ctrl-l, and sometimes I forget.

...
> The reason this function doesn't do anything for null inputs is you've
> declared it STRICT.  So it doesn't get called at all, and you get no
> rows out:

Oops my bad, I read the doc diagonaly and missed this one.

...
> If that were the correct explanation, you'd have been getting the whole
> table back, not none of it.

Yep, its working correctly now, thanks Tom.

--
Out of the mouths of babes does often come cereal.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: test strange behavior
Next
From: "Jean-Yves F. Barbier"
Date:
Subject: function refused