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

Re: use of / in ~ vs. ~*

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: use of / in ~ vs. ~*
Date: 2000-09-27 00:06:37
Message-ID: 5155.970013197@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Hannu Krosing <hannu(at)tm(dot)ee> writes:
> Can anyone explain why I must make / a character class 
> in case-insensitive query in order to match / ?

What LOCALE are you using?  There was a thread about strange ordering
rules confusing the LIKE/regexp optimizer recently ...

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Mikheev, VadimDate: 2000-09-27 00:23:57
Subject: RE: RE: [GENERAL] update inside transaction violates unique constraint?
Previous:From: Mikheev, VadimDate: 2000-09-26 23:05:49
Subject: RE: RE: [GENERAL] update inside transaction violates unique constraint?

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