Re: what is similar to like operator in mysql for postgresql

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: hatem gamal elzanaty <hatem(at)softpro(dot)bz>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: what is similar to like operator in mysql for postgresql
Date: 2011-07-10 21:11:10
Message-ID: CAOR=d=2_wtqL5onCeZwuTaa-2kod25aqtzSBJ-AztzhQqhDXFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sun, Jul 10, 2011 at 1:35 PM, hatem gamal elzanaty <hatem(at)softpro(dot)bz> wrote:
> hi all,
> can you tell me what is similar to like operator in mysql for postgresql
> hatem gamal

In postgresql ilike is like mysql's case insensitive like. like in
postgres is case sensitive.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Gavin Flower 2011-07-10 22:48:03 Re: [SQL] using explain output within pgsql
Previous Message Pavel Stehule 2011-07-10 20:18:19 Re: [SQL] using explain output within pgsql