Kip Cole writes:
> 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…
You've got the syntax off a bit. The argument of COLLATE is an
identifier, n
On Sat, May 21, 2022 at 4:38 PM Kip Cole wrote:
> 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.
You cannot cast between a token that interpreted as a literal and one that
is interpreted as a name. Fo
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: s
