Re: ORDER BY with plpgsql parameter
| От | Thomas Schoen |
|---|---|
| Тема | Re: ORDER BY with plpgsql parameter |
| Дата | |
| Msg-id | 200406021036.47032.t.schoen@vitrado.de обсуждение |
| Ответ на | ORDER BY with plpgsql parameter (Thomas Schoen <t.schoen@vitrado.de>) |
| Ответы |
Re: ORDER BY with plpgsql parameter
Re: ORDER BY with plpgsql parameter |
| Список | pgsql-general |
> You need to use the FOR-IN-EXECUTE style of query. That way > you can use any string you want (including text passed in as > a parameter) to build the query inside the function ... that is what i want to avoid. (i wrote that in my first mail) My question was about why it is not possible to do it like this: ....ORDER BY $1 I don't know if it is standards-conform or if someone considers it a usefull feature, but i think it would help users to write capsulated statistics-functions or simply browsable and orderable lists.
В списке pgsql-general по дате отправления: