Horton

Re: [HACKERS] Bug in LIKE ?

Marc G. Fournier <scrappy@hub.org>

View thread
From: The Hermit Hacker <scrappy@hub.org>
To: Chris Bitmead <chris.bitmead@bigfoot.com>
Cc: pgsql-hackers@hub.org
Date: 1999-06-07T07:35:37Z
Lists: pgsql-hackers 
On Mon, 7 Jun 1999, Chris Bitmead wrote:

> 
> Does the following indicate a bug in LIKE ? Using CVS from about a week
> ago.
> 
> =>select oid,title from category* where title like 'Sigma%';

If I understand this correctly, IMHO, this would be asking for '^Sigma'
with at least one character after the 'a' ...

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org