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(at)acm(dot)org> wrote in message
> news:m3u17gsxhe(dot)fsf(at)chvatal(dot)cbbrowne(dot)com(dot)(dot)(dot)
> > Quoth "Relaxin" <noname(at)spam(dot)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(at)postgresql(dot)org
>

--
Darren Ferguson