> Now when I'm searching database for word "chris" i can't find word
> "Chris" - how the SELECT should looks like?
select name from nametable where lower(name) = 'chris';
or
select name from nametable where upper(name) = 'CHRIS';
-Nick
PS: I'd suggest taking general SQL questions like this to the pgsql-general
list.
---------------------------------------------------------------------
Nick Fankhauser
Business:
[EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/
Personal:
[EMAIL PROTECTED] http://www.fankhausers.com
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
