Re: LIKE with spaces

From: Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE>
To: JB <jimbag(at)kw(dot)igs(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: LIKE with spaces
Date: 2000-04-11 10:23:21
Message-ID: Pine.GSO.4.02A.10004111221490.7708-100000@Myrslok.DoCS.UU.SE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Brothers 2000-04-11 10:58:00 DB Journalling?
Previous Message omid omoomi 2000-04-11 06:01:16 Re: PHP-Postgres link