Re: [GENERAL] CASE in where statement. BUG ??

This is normaol behavior. > I belive that I have found a bug - or maybe it was done on purpose. Have > a look at this query: > > > SELECT integer_field FROM bugtable WHERE (CASE WHEN '' <> '' THEN > integer_field = '' ELSE integer_field = 0 END); > Result: ERROR: invalid input syntax for integer:

Re: [GENERAL] PostgreSQL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I confirm this behavour: cyrilic words are not changed by lower()/upper() functions, nor catched by ilike. I am using : => SELECT version(); version - --- Postgr