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