| From: | Oluwatope Akinniyi <topeakinniyi(at)hotmail(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | What is the difference? |
| Date: | 2009-03-06 08:50:27 |
| Message-ID: | BLU128-W4523FD3F40213696A3E669DBA50@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
This
SELECT 1 WHERE '95b5a221aeba15c' IN (E'\'' || replace('95b5a221aeba15c+fb4e7219ab898ce+b08586cb81059f9','+',''',''') || E'\'') returns no row while
SELECT 1 WHERE '95b5a221aeba15c' IN ('95b5a221aeba15c','fb4e7219ab898ce','b08586cb81059f9') returns a row.
What is the difference between E'\'' || replace('95b5a221aeba15c+fb4e7219ab898ce+b08586cb81059f9','+',''',''') || E'\'' and '95b5a221aeba15c','fb4e7219ab898ce','b08586cb81059f9'?
Cheers,
Chris
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oluwatope Akinniyi | 2009-03-06 09:06:48 | Posts not showing |
| Previous Message | Nico Grubert | 2009-03-06 07:35:33 | Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist |