Re: LIKE with spaces - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: LIKE with spaces
Date
Msg-id Pine.GSO.4.02A.10004111221490.7708-100000@Myrslok.DoCS.UU.SE
Whole thread Raw
In response to LIKE with spaces  (JB <jimbag@kw.igs.net>)
List pgsql-general
On Mon, 10 Apr 2000, JB wrote:

> I'm using a query ... WHERE streetname LIKE 'ST DAV%' but, of course it
> doesn't work.

Define "doesn't work".

> LIKE 'ST%' does work however, so I assume the space is
> causing some grief to the query parser.

Not here. I'm using 7.0 beta. Not sure if there were changes in these
things, maybe you could dig around in the release notes.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-general by date:

Previous
From: Kwan Lai Sum
Date:
Subject: postgres 6.5.2 user problem
Next
From: John Brothers
Date:
Subject: DB Journalling?