select (\'\' ~* \'\')=true while select (\'\' ilike \'\')

From: desoft(at)freemail(dot)gr
To: pgsql-admin(at)postgresql(dot)org
Subject: select (\'\' ~* \'\')=true while select (\'\' ilike \'\')
Date: 2010-02-25 18:14:03
Message-ID: 4b86bdeb03d3c8.17572985@freemail.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


I have a freshly compiled installation of postresql on ubuntu 9.10.

Why select ('γ' ~* 'Γ') = ('γ' ilike 'Γ') IS FALSE ?

encoding is set correctly.

While ilike works correctly ~* doesn't why ?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tomeh, Husam 2010-02-25 23:04:19 Altering a column (increasing size) in Postgres takes long time
Previous Message Iñigo Martinez Lasala 2010-02-24 08:31:54 Re: how do I do dump and restore without bugging with constraint?