On 2020-11-20 08:13, Dirk Mika wrote:
we come from the Oracle world and we have an application that, depending on a
setting, sends the command ALTER SESSION SET NLS_SORT=... when connecting to
the database.
Is there a similar way to set a COLLATE for a session in PostgreSQL?
I know that I can specify a COLLATE for a SELECT statement in the ORDER BY
Clause, but then I would have to adjust the statements in the client and
statements that are automatically generated by the database components used,
would not be affected.
There is a SET COLLATION command in the SQL standard that does this.
Someone just has to implement it. It wouldn't be terribly difficult, I
think.
