Re: Column Name parameter problem - Mailing list pgsql-bugs

From David Fetter
Subject Re: Column Name parameter problem
Date
Msg-id 20050928194827.GB30869@fetter.org
Whole thread Raw
In response to Column Name parameter problem  (vishal saberwal <vishalsaberwal@gmail.com>)
List pgsql-bugs
On Wed, Sep 28, 2005 at 12:25:54PM -0700, vishal saberwal wrote:
> hi,
>
> I am trying to create a stored procedure that takes a column name as
> parameter and then uses it to sort the table for result set.

You can't currently do this in PL/PgSQL.  I believe this is scheduled
for a fix in 8.2, but for now, use another PL like PL/Perl, or (if
you're brave ;) C.

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

pgsql-bugs by date:

Previous
From: vishal saberwal
Date:
Subject: Column Name parameter problem
Next
From: Tom Lane
Date:
Subject: Re: BUG #1916: selection criteria from one outer join on clause applied to other joins