Re: ORDER BY with plpgsql parameter - Mailing list pgsql-general

From Thomas Schoen
Subject Re: ORDER BY with plpgsql parameter
Date
Msg-id 200406021036.47032.t.schoen@vitrado.de
Whole thread Raw
In response to ORDER BY with plpgsql parameter  (Thomas Schoen <t.schoen@vitrado.de>)
Responses Re: ORDER BY with plpgsql parameter
Re: ORDER BY with plpgsql parameter
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Providing the password to psql from a script
Next
From: Richard Huxton
Date:
Subject: Re: ORDER BY with plpgsql parameter