Casting a collation in an ORDER BY ... COLLATE - Mailing list pgsql-general

From Kip Cole
Subject Casting a collation in an ORDER BY ... COLLATE
Date
Msg-id DAAAF3FE-890E-44C7-AD59-04C16AC859B7@gmail.com
Whole thread Raw
Responses Re: Casting a collation in an ORDER BY ... COLLATE
Re: Casting a collation in an ORDER BY ... COLLATE
List pgsql-general
I’m trying to cast a string value to a collation name without success. My suspicion is this isn’t possible
based upon the error message. But perhaps wiser heads than mine have a suggestion on how to do
this?

cldr_sql=# select * from models order by name collate 'en-x-icu'::regcollation;
ERROR: syntax error at or near "'en-x-icu'"
LINE 1: select * from models order by name collate 'en-x-icu'::regco…

Utilmately the objective is to interpolate the collation value into a prepared query so
this is just the first step to validate that casting a COLLATE name  is possible or not.

Suggestions and ideas most welcome.






pgsql-general by date:

Previous
From: Koen De Groote
Date:
Subject: Re: In case of network issues, how long before archive_command does retries
Next
From: "David G. Johnston"
Date:
Subject: Re: Casting a collation in an ORDER BY ... COLLATE