From: Jaroslav Sivy <yarex@pobox.sk>
To: pgsql-sql@postgresql.org
Subject: Sql ORDER BY and ASC/DESC question
Date: Wed, 30 Jan 2008 11:35:51 +0100
Message-ID: <aa457f86948348248e93c6fc38b4b1f6@pobox.sk> (raw)
Hello everyone,
I have following problem: am using pl/sql functions to trigger some sql code and i need to pass ORDER_BY column name and ASC/DESC sorting order as an input parameters into that function
and order the result based on these input parameters.
The problem is, that the only way is to create query as "string" and then execute it as "string".
Is there any other way around how to avoid that "string query"?
(i don't want to use IFs either, because 5 columns x 2 sorting orders would require 10 IFfed queries with different column/sorting order combination)
If it's not possible, could anyone implement this feature into one of future versions? I think that it would be quite handy to have something like that.
Thank you for your responses.
-------------------
Menu.sk - Denne aktualizovany zoznam obedovych menu a restauracii s presnou lokalizaciou.
Attachments:attachment.txt (text/plain, 47B) download
Put the text of the welcome message here.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: yarex@pobox.sk
Subject: Re: Sql ORDER BY and ASC/DESC question
In-Reply-To: <aa457f86948348248e93c6fc38b4b1f6@pobox.sk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox