Dynamic collation support

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Dynamic collation support
Дата
Msg-id CAHyXU0y16yvSR+Gg3BN--vFpxaE8as=2XNLF24291hsO4acx6w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Dynamic collation support
Список pgsql-general
For database functions, is there any way to manage collations besides
dynamic sql?  It doesn't look like there is but I thought I'd ask.

For example, I want to do something like:

DO
$$
DECLARE
  c name DEFAULT 'en_GB';
BEGIN
  SELECT * FROM foo ORDER BY a COLLATE c;
END;
$$;

and not

DO
$$
DECLARE
  c name DEFAULT 'en_GB';
BEGIN
  EXECUTE 'SELECT * FROM foo ORDER BY a COLLATE ' || quote_ident(c);
END;
$$;

I understand this would disable all index supported sorting; that's ok.

Not being able to specify collation in a parameterized manner presents
some issues...I'm curious if there are workarounds.

merlin


В списке pgsql-general по дате отправления:

Предыдущее
От: DerekW
Дата:
Сообщение: Re: Error installing 9.5 on Win 2012 R2: data dir not created
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Dynamic collation support