Re: [HACKERS] Unclear documentation

2005-11-09 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > 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 the

[HACKERS] Unclear documentation

2005-11-09 Thread Christopher Kings-Lynne
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 a

[HACKERS] Unclear documentation of to_char()

2003-02-23 Thread Peter Eisentraut
The documentation of to_char() is unclear regarding the meaning of the various formatting patterns for plus and minus signs: S negative value with minus sign (uses locale) MI minus sign in specified position (if number < 0) PL plus sign in specified position (if number > 0) SG