Forum OpenACS Q&A: Re: Postgress plpgsql question

Collapse
Posted by Vinod Kurup on
Hi Steve,

Since the body of a PLPGSQL function is enclosed in single quotes, any single quotes within the function must themselves be quoted. Basically, wherever you see a single quote in a non-plpgsql statement, you need 2 in a plpgsql statement.

See Roberto's guide for examples of how complex this can get 😊