Re: [ADMIN] lower/upper case

[Peter Eisentraut]

On Fri, 17 Mar 2000, J Carlos Morales Duarte. wrote:

> 
> 
> select * from books where titulo like '%perl%';
> 
> select * from books where titulo like '%Perl%';
> 
> 
> in This querys, postgres return diferents registers, but i need return
> the same registers... what i doing?

select * from books where lower(titulo) like '%perl%';


-- 
Peter Eisentraut                  Sernanders v�g 10:115
[EMAIL PROTECTED]                   75262 Uppsala
http://yi.org/peter-e/            Sweden