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
Re: Bug in LIKE operator processing |
Список | 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 по дате отправления: