Forum OpenACS Q&A: Response to next_day for PG 7.2

Collapse
2: Response to next_day for PG 7.2 (response to 1)
Posted by Don Baccus on 07/04/02 10:23 PM
Since PL/pgSQL function bodies are strings you need to double up your apostrophes.  ''7.2'' not '7.2.', for instance.

This is a common error and there's talk in PG land of changing the parser to take an unquoted string followed by a unique delimiter much as is done in Oracle.  But that lies in the future ...