On Tue, Dec 13, 2011 at 10:53 AM, David Johnston <polobo@xxxxxxxxx> wrote: > Aside from backward compatibility, and the various warnings, is there any > reason to prefer dollar-quoting over a non-SQL-escaped string literal (i.e., > '3[A-Z\-\(\) ]' ) ? yeah -- because sooner or later you have to stick a single quote in there (of course, you can double the ', but I personally think that's awful). merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general