From: | "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in> |
---|---|
To: | "Michael Glaesemann" <grzm(at)myrealbox(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: regarding the apostrophe character |
Date: | 2005-11-28 12:20:44 |
Message-ID: | 967CFC4343BF2A4DAFACD026D33DC85118EC94@jal.iiitb.ac.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
and what about the backslash character ...
do we need to escape it as well? or it is treated as a normal character
________________________________
From: Michael Glaesemann [mailto:grzm(at)myrealbox(dot)com]
Sent: Fri 11/25/2005 4:17 PM
To: surabhi.ahuja
Cc: pgsql-general(at)postgresql(dot)org
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2005-11-28 12:23:03 | Re: regarding the apostrophe character |
Previous Message | surabhi.ahuja | 2005-11-28 12:18:37 | Re: postmaster does not come up |