Skip site navigation (1) Skip section navigation (2)

Re: problem with select where like ']'

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: depesz(at)depesz(dot)pl, PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: problem with select where like ']'
Date: 2000-10-17 22:43:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Tom Lane wrote:
> hubert depesz lubaczewski <depesz(at)depesz(dot)pl> writes:
> > but i'm just wondering why like ']' doesn't work.
> What LOCALE setting are you running the postmaster in?
> ']' is not a special character as far as LIKE is concerned, but
> I suspect you may be seeing another variant of the problems that
> LIKE index optimization has with peculiar collation rules.
> You can find plenty of discussion of this in the mailing list archives
> :-(

WHAT mailing list archives?

They aren't linked to anywhere on that I can find.

Joseph Shraibman
Increase signal to noise ratio.

In response to


pgsql-sql by date

Next:From: Tom LaneDate: 2000-10-17 23:29:21
Subject: Re: problem with select where like ']'
Previous:From: John HaslerDate: 2000-10-17 22:25:19
Subject: Re: nested transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group