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

From Thomas Schoen
Subject Re: ORDER BY with plpgsql parameter
Date
Msg-id 200406021958.50911.t.schoen@vitrado.de
Whole thread Raw
In response to Re: ORDER BY with plpgsql parameter  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Thank you all for your detailed answers!

My conclusion is:
- Use "FOR IN EXECUTE" if you want to sort by many different columns depending
on the function paramaters.
- Use "IF" and a seperate SQL-statement for every sort-column provided by the
function parameter if you only want to sort by a few different columns and
want to optimize the performance of your function.

pgsql-general by date:

Previous
From: Shachar Shemesh
Date:
Subject: Re: ODBC, ADO, Return Value from SP problem
Next
From: Bruno Wolff III
Date:
Subject: Re: GRANT question