Re: [GENERAL] Weird "LIKE" behaviour

2012-07-06 Thread David Johnston
> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Andy Chambers > Sent: Friday, July 06, 2012 4:34 PM > To: pgsql > Subject: Re: [GENERAL] Weird "LIKE" behaviour > > On Fri, Jul

Re: [GENERAL] Weird "LIKE" behaviour

2012-07-06 Thread Andy Chambers
On Fri, Jul 6, 2012 at 4:26 PM, David Johnston wrote: >> -Original Message- >> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- >> ow...@postgresql.org] On Behalf Of Andy Chambers >> Sent: Friday, July 06, 2012 4:17 PM >> To: pgsql >

Re: [GENERAL] Weird "LIKE" behaviour

2012-07-06 Thread David Johnston
> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Andy Chambers > Sent: Friday, July 06, 2012 4:17 PM > To: pgsql > Subject: [GENERAL] Weird "LIKE" behaviour > > Below are two quer

[GENERAL] Weird "LIKE" behaviour

2012-07-06 Thread Andy Chambers
Below are two queries that should be pretty much the same but with the first one, I'm trying to boil it down to a minimal test-case so I don't have to export the table definition of dcm.providers. The first one returns nothing but at least executes the query. => create table foo ( foo text ); =>