Casting a collation in an ORDER BY ... COLLATE

Поиск
Список
Период
Сортировка
От Kip Cole
Тема Casting a collation in an ORDER BY ... COLLATE
Дата
Msg-id DAAAF3FE-890E-44C7-AD59-04C16AC859B7@gmail.com
обсуждение исходный текст
Ответы Re: Casting a collation in an ORDER BY ... COLLATE  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Casting a collation in an ORDER BY ... COLLATE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Koen De Groote
Дата:
Сообщение: Re: In case of network issues, how long before archive_command does retries
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Casting a collation in an ORDER BY ... COLLATE