Hi,
On Thursday 25 January 2007 11:52, Alexander B. wrote:
| One developer asked me about case-sensitive, if its possible disable
| Postgres not consider when using comparative functions.
| Eg.:
| select * from people
| where upper(name) like upper('A%');
|
| Is there any parameter that don't take in account case-sensitive, or any
| other way to treat??
name ilike 'a%';
name ~* '^a';
For pattern matching operators you can take a look at
http://www.postgresql.org/docs/8.2/interactive/functions-matching.html
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> ---- http://rp-online.de/ ----
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
