From: | "Anton Stckl" <tony(at)cys(dot)de> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] Case in-sensitive searches |
Date: | 1998-05-19 14:05:25 |
Message-ID: | 356191A5.B64FD6A2@cys.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Jose' Soares Da Silva wrote:
>
> On Tue, 19 May 1998, Marin D wrote:
>
> >
> > upper()/lower() are defined only for text fields. How to deal with charN ?
> >
> version 6.3:
>
> prova=> create table a ( var varchar(20), ch char(30));
> CREATE
> prova=> insert into a values ('nome','pippo');
> INSERT 76394 1
> prova=> select * from a;
> var |ch
> ----+------------------------------
> nome|pippo
> (1 row)
>
> prova=> select upper(var), upper(ch) from a;
> upper|upper
> -----+------------------------------
> NOME |PIPPO
> (1 row)
> Jose'
>From http://www.postgresql.org/docs/user/c05.htm :
Operator Description Usage
~* Match (regex), case insensitive 'thomas' ~* '*.Thomas*.'
Ex:
Select * From table_membres where nom ~* '.*myname.*';
-Tony
--
----------C-Y-B-E-R-S-O-L-U-T-I-O-N-S----------------
Anton Stöckl mailto:tony(at)cys(dot)de
CyberSolutions GmbH http://www.cys.de
Frankfurter Ring 193A Phone +49 89 32369223
80807 Muenchen Fax +49 89 32369220
------W-E----M-A-K-E----I-T----P-O-S-S-I-B-L-E-------
From | Date | Subject | |
---|---|---|---|
Next Message | Jerome Knobl | 1998-05-19 17:45:08 | Exhausted memory |
Previous Message | The Web Administrator | 1998-05-19 13:22:39 | Re: [SQL] How to handle a requirement for nextval |