On Nov 23, 2007, at 12:06 , Louis-David Mitterrand wrote:
On Wed, Nov 21, 2007 at 09:14:14AM +0100, Bart Degryse wrote:
LANGUAGE plpgsql VOLATILE RETURNS NULL ON NULL INPUT;
Hi,
I was curious as to why you created this function with a prototype of
func(intext IN text, outtext OUT text) ... returns NULL
Don't confuse RETURNS NULL ON NULL INPUT with the function return
value: this is the verbose spelling of STRICT.
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
