Bruce Momjian wrote:
> Agreed we have to show both. The question is whether we should prefer
> single quotes and switch to $$ only when a single quote exists in the
> body, or use $$ in most cases. Of course CREATE FUNCTION should show
> that both are possible, as well as $tag$.
My take: If there are no single quotes inside, use '. If there are
single quotes inside, use $$. If there is $$ inside, use $x$ (or some
other short sequence, not the function name). This conveys the
decision process we made when we designed this feature. If there are
several related examples in one section, use the same method for all.