Bug in LIKE operator processing

Поиск
Список
Период
Сортировка
От Żak, Sławomir
Тема Bug in LIKE operator processing
Дата
Msg-id 2560F40A346E1C42A18A2C49A058F206101040@AMON.corponet.era.pl
обсуждение исходный текст
Ответы Re: Bug in LIKE operator processing  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Bug in LIKE operator processing  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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,
so I think it's a standard SQL query.

Table is defined as:

host=> \d os                                   Table "os" Column   |         Type          |
Modifiers                   
-----------+-----------------------+-----------------------------------------------id        | integer               |
notnull default nextval('"os_id_seq"'::text)name      | character varying(32) | major     | integer               |
minor    | integer               | subrev    | character(16)         | string_id | character(32)         |  
Unique keys: os_id_key

PostgreSQL version is 7.3.1

Is it non-implemented by design, or maybe I've overlooked something?

Thanks, /S


В списке pgsql-bugs по дате отправления:

Предыдущее
От: joost@snow.nl
Дата:
Сообщение: year and weeknumbers (proposal included)
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: No migration path for MONEY