views:

15

answers:

0

I try to compare strings in PostgreSQL.

Here are queries that I execute:

select 'UK (z'>'Ukraine';

This one returns true;

Then I try following one:

select 'UK ('>'Ukraine';

This one returns false;

I think, that both of these should return false , and on another PostgreSQL server it behaves correctly. But main server is producing incorrect results in such operations. What am I doing wrong?