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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org