| From: | Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: What is the difference? |
| Date: | 2009-03-06 09:31:18 |
| Message-ID: | 20090306103118.54403e57@dawn.webthatworks.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 6 Mar 2009 09:50:27 +0100
Oluwatope Akinniyi <topeakinniyi(at)hotmail(dot)com> wrote:
>
> 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'?
You assume that the statement is interpreted twice.
The first is comparing your needle with an array/recordset of just
one element
"'95b5a221aeba15c','fb4e7219ab898ce','b08586cb81059f9'"
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2009-03-06 10:13:25 | Re: Posts not showing |
| Previous Message | Richard Huxton | 2009-03-06 09:08:29 | Re: What is the difference? |