Re: quotes etc

On 02/22/2011 04:18 PM, Adrian Klaver wrote:
> On Tuesday, February 22, 2011 12:26:41 pm John Fabiani wrote:
>
>  > Hi,
>
>  > I would have thought that there would be a simple built-in function that
>
>  > would escape the quotes as ('D' Andes') to ('D\' Andes'). But I did not
>
>  > see anything?
>
>  >
>
>  > I am I wrong?
>
>  >
>
>  > Johnf
>
> Dollar quoting ? :
>
> http://www.postgresql.org/docs/9.0/interactive/sql-syntax-lexical.html
>
> 4.1.2.4. Dollar-Quoted String Constants
>
> test(5432)aklaver=>SELECT $$D' Andes$$;
>
> ?column?
>
> ----------
>
> D' Andes

I like this $str$....$str$ very much!

Vote for this!
--
Lu Ying