Hi,
Well while moving from Mysql to POstgresql this was one more difference
: Case Sensitivity.
The problem is in this query
select * from table where name='Word'
select * from table where name='word'
Mysql treated both as same but postgres does not..i appreciate that
it is good but is there a way that 'Word' can be matched with 'word'?
i mean my queries can specify whether to be case sensitive or not.
is there any such provision in postgres?
or is it always case sensitive?
thanks
--
------
Varun
It is easier to write an incorrect program than understand a correct one