In the CREATE FUNCTION docs I notice this:

RETURNS NULL ON NULL INPUT or STRICT indicates that the function always returns null whenever any of its arguments are null. If this parameter is specified, the function is not executed when there are null arguments; instead a null result is assumed automatically.

I'm wondering what this means when the function returns a composite type, or a setof scalar or a setof composite?

So if you indicate STRICT, does PostgreSQL assume one row of all nulls for each column in the return composite type? Perhaps someone who knows better could tweak the docs a bit?

Cheers,

Chris


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to