From: Michael Glaesemann [mailto:grzm@xxxxxxxxxxxxx]
Sent: Fri 11/25/2005 4:17 PM
To: surabhi.ahuja
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] regarding the apostrophe character
***********************
Your mail has been scanned by
InterScan VirusWall.
***********-***********
On Nov 25, 2005,
at 13:40 , surabhi.ahuja wrote:
> in which version will the use of
"Escape string syntax " be
> supported ..
I know they work in
8.1. You can check the release notes:
http://www.postgresql.org/docs/current/interactive/release.html
The
SQL standard way of escaping single-quotes is ''.
test=# select
version();
version
------------------------------------------------------------------------
----------------------------------------------------------------------
PostgreSQL
8.1.0 on powerpc-apple-darwin8.3.0, compiled by
GCC
powerpc-apple-darwin8-gcc-4.0.0 (GCC) 4.0.0 (Apple Computer,
Inc.
build 5026)
(1 row)
test=# select 'foo''s bar' as
sql_standard
test-# , e'foo\'s bar' as
e_escape
test-# , $$foo's bar$$ as
dollar_quote;
sql_standard | e_escape |
dollar_quote
--------------+-----------+--------------
foo's
bar | foo's bar | foo's bar
(1 row)
Michael
Glaesemann
grzm myrealbox
com
