From: | KuroiNeko <evpopkov(at)carrier(dot)kiev(dot)ua> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: problem with select where like ']' |
Date: | 2000-10-17 20:07:29 |
Message-ID: | 39ECB181.nail8J114GAI@ed.ed |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> 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.
OTOH, it seems like it shouldn't return any rows, as the original
statement has no metacharachters, % or _
--
Well I tried to be meek
And I have tried to be mild
But I spat like a woman
And I sulked like a child
I have lived behind the walls
That have made me alone
Striven for peace
Which I never have known
Dire Straits, Brothers In Arms, The Man's Too Strong (Knopfler)
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-10-17 20:49:45 | Re: nested transactions |
Previous Message | Tom Lane | 2000-10-17 19:33:38 | Re: problem with select where like ']' |