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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <desoft(at)freemail(dot)gr>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: select (\'*\' ~* \'*\')=true while select (\'*\' ilike \'*\')
Date: 2010-03-11 16:38:05
Message-ID: 4B98C80D020000250002FC74@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<desoft(at)freemail(dot)gr> wrote:

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

What PostgreSQL version? Compiled with what configuration options?

> encoding is set correctly.

To what? With what character set, collation, etc.?

You've posted some of the information needed to understand the
problem, but please review this for ideas on what else might help
people identify the cause:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-03-11 16:50:44 Re: select (\' \' ~* \' \')=true while select (\' \' ilike \' \')
Previous Message Matt Janssen 2010-03-10 16:29:18 pg_dump / pg_restore with Large Objects from 32-bit to 64-bit