Home > mailing lists

What is the difference? - Mailing list pgsql-general

From	Oluwatope Akinniyi
Subject	What is the difference?
Date	March 6, 2009 04:50:33
Msg-id	BLU128-W4523FD3F40213696A3E669DBA50@phx.gbl Whole thread Raw
Responses	Re: What is the difference? Re: What is the difference?
List	pgsql-general

Tree view

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

Get news, entertainment and everything you care about at Live.com. Check it out!

pgsql-general by date:

From: Scott Marlowe
Date: 06 March 2009, 03:39:45
Subject: Re: Performance of subselects

From: Richard Huxton
Date: 06 March 2009, 05:30:34
Subject: Re: What is the difference?

What is the difference? - Mailing list pgsql-general

Previous

Next