problem with select where like ']'
От | hubert depesz lubaczewski |
---|---|
Тема | problem with select where like ']' |
Дата | |
Msg-id | 20001017210251.A4327@cyber.cs.net.pl обсуждение исходный текст |
Ответы |
Re: problem with select where like ']'
|
Список | pgsql-sql |
hi, i have a table (view actually) which contains field "article_name" which is written like: [AGD]|[Kuchenki Mikrofalowe]|[Samsung AKMS1] i.e. some string within "[]" delimited by "|" i want to select all record that have "[AGD]|[" in front of them so i tried select * from my_view where article_name like '[AGD]|['; this doesn't work. no errors, but no tuples returned. i checked that the problem is character ']'. '[' works o.k. '|' - i guess works too. but inserting "]" makes the whole expression doesn't work i tried escaping of it like \], \\] or even \\\] but none of these worked. right now i'm using comparison: where substring (...) = '...' and it works even with those "]" signs. but i'm just wondering why like ']' doesn't work. any ideas? depesz p.s. sorry for my english. -- hubert depesz lubaczewski <=--=> adres www usuniêty na pro¶bê Asi ¦l. ------------------------------------------------------------------------ najwspanialsz± rzecz± jak± da³o nam nowoczesnespo³eczeñstwo, jest niesamowita wrêcz ³atwo¶æ unikania kontaktów z nim ...
В списке pgsql-sql по дате отправления: