Dynamic expressions set in "order by" clause - Mailing list pgsql-general

From Sergey Konoplev
Subject Dynamic expressions set in "order by" clause
Date
Msg-id c3a7de1f0711210748y56ca96f6sfec783b09e0ba230@mail.gmail.com
Whole thread Raw
Responses Re: Dynamic expressions set in "order by" clause  (Erik Jones <erik@myemma.com>)
List pgsql-general
Hello,

I have a procedure which takes few arguments. The arguments must
affect expressions set of "order by" clause. For instance in one case
ordering must be performed by 1st, 2nd (desc) and 3rd fields but in
another by 3rd, 1st and 2nd fields.

Is there a way to manage it without using dynamic queries (execute
'...') and code duplicating?

--
Regards,
Sergey Konoplev

pgsql-general by date:

Previous
From: "Rodrigo De León"
Date:
Subject: Re: Table filter
Next
From: Andreas Kretschmer
Date:
Subject: Re: loading a funtion script from a file