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.
