Received: from cyber.cs.net.pl (cyber.cs.net.pl [195.117.250.3]) by hub.org (8.10.1/8.11.0) with SMTP id e9HJ3IW96811 for ; Tue, 17 Oct 2000 15:03:19 -0400 (EDT) (envelope-from depesz@cyber.cs.net.pl) Received: (qmail 4348 invoked by uid 1158); 17 Oct 2000 19:02:51 -0000 Message-ID: <20001017210251.A4327@cyber.cs.net.pl> Date: Tue, 17 Oct 2000 21:02:51 +0200 From: hubert depesz lubaczewski To: PGSQL-SQL Subject: problem with select where like ']' Reply-To: depesz@depesz.pl Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Mailer: Mutt 0.93i X-Mutt-Fcc: =selfmail X-Archive-Number: 200010/158 X-Sequence-Number: 1820 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 nowoczesne społeczeństwo, jest niesamowita wręcz łatwość unikania kontaktów z nim ...