PostgreSQL compare string setting

Question

I have one query, which returns different results on different servers.

select ' s' > '.'

First server return true, second - false. What the are the settings that can cause this?

Lukasz Szozda · Accepted Answer · 2018-08-14 18:09:46Z

1

Your DBs have different COLLATION:

The collation feature allows specifying the sort order and character classification behavior of data per-column, or even per-operation. This alleviates the restriction that the LC_COLLATE and LC_CTYPE settings of a database cannot be changed after its creation.

select name, setting
from pg_settings
where name in ('lc_collate', 'server_encoding', 'client_encoding');

-- explicit collation
select ' s' COLLATE "POSIX" > '.' COLLATE "POSIX"

SQLFiddle Demo

edited Aug 14, 2018 at 18:09

answered Aug 14, 2018 at 17:50

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL compare string setting

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related