Re: Bug in LIKE operator processing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Żak, Sławomir <SZak(at)era(dot)pl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug in LIKE operator processing
Date: 2003-01-28 22:37:02
Message-ID: 4483.1043793422@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?iso-8859-2?Q?=AFak=2C_S=B3awomir?= <SZak(at)era(dot)pl> writes:
> I've found that statement:
> SELECT * FROM os WHERE 'FreeBSD 4.7-RC'
> LIKE string_id; (one of string_id's is 'FreeBSD 4.7%')
> doesn't work. No error is reported. It does work in Oracle,

It'd probably work in Postgres too, if you'd used varchar(n) rather than
char(n) for string_id. As is, the trailing spaces in string_id are
considered significant.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-01-28 22:47:14 Re: No migration path for MONEY
Previous Message Michiel Lange 2003-01-28 21:27:37 Bug with usernames that are only numbers