Like seems to fail !
От | Yves Martin |
---|---|
Тема | Like seems to fail ! |
Дата | |
Msg-id | 00112008291300.01625@pcyma.elca.ch обсуждение исходный текст |
Ответы |
Re: Like seems to fail !
|
Список | pgsql-sql |
Hello, I have a strange problem with 'like' behaviour when I upgrade from 6.5 to 7.0 Here is my table : create table persistent_config ( key varchar primary key, type varchar(12), value varchar not null ) and its content : base=# select * from persistent_config; key | type | value ------------+------+--------------/test/info | | avalue/try/info | | avalue/test/key | | changedvalue (3 rows) And I try this 'like' command in psql : base=# select * from persistent_config where key like '/test%'; key | type | value ------------+------+--------------/test/info | | avalue/test/key | | changedvalue (2 rows) Result is ok ! By now, this other one : base=# select * from persistent_config where key like '/%';key | type | value -----+------+------- (0 rows) There is really something wrong ! All current content should have been returned. Is '/' caracter a new 'escape' caractersince version 6.5 In fact, my query was working well on postgresql 6.5 and since I upgraded to 7.0, this simplecommand failed. Is it a bug, or I missed something ? Regards, -- Yves Martin yma, Lausanne
В списке pgsql-sql по дате отправления: