Re: Dynamic collation support

2016-01-19 16:07 GMT+01:00 Merlin Moncure <mmoncure(at)gmail(dot)com>:

> 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.
>

Different collates requires different plans - so using dynamic SQL is much
more correct.

It is same like using variables as columns or tablenames.

Regards

Pavel

>
> merlin
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>