Re: case-insensitive database

select * from stocks where lower(symbol) = 'aadbx';
or
select * from stocks where symbol ilike =aadbx';
or
select * from stocks where symbol ~* 'aadbx';


HTH
Darren
On Sat, 13 Sep 2003, Relaxin wrote:

> No, I mean the data.
>
> select * from stocks where symbol = 'AADBX'
> and
> select * from stocks where symbol = 'aadbx'
>
> would bring up the same result set.
>
>
> "Christopher Browne" <cbbrowne@acm.org> wrote in message
> news:m3u17gsxhe.fsf@chvatal.cbbrowne.com...
> > Quoth "Relaxin" <noname@spam.com>:
> > > Is there a way to make Postgresql case-INSENSITIVE?
> >
> > It already is.
> >
> > portfolio=# select * from stocks limit 1;
> >  symbol | description | exchange
> > --------+-------------+----------
> >  AADBX  | AADBX       | NYSE
> > (1 row)
> >
> > portfolio=# sELeCT * FROM STOCKS LIMIT 1;
> >  symbol | description | exchange
> > --------+-------------+----------
> >  AADBX  | AADBX       | NYSE
> > (1 row)
> >
> > Those queries were cased differently, but were recognized as being
> > functionally identical.
> > --
> > output = ("aa454" "@" "freenet.carleton.ca")
> > http://cbbrowne.com/info/linux.html
> > debugging, v:
> >         Removing the needles from the haystack.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

--
Darren Ferguson