Re: Column Name parameter problem

From: David Fetter <david(at)fetter(dot)org>
To: vishal saberwal <vishalsaberwal(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Column Name parameter problem
Date: 2005-09-28 19:48:27
Message-ID: 20050928194827.GB30869@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Chris Browne 2005-09-28 21:15:10 Re: Postgresql problem in AIX 5.3
Previous Message vishal saberwal 2005-09-28 19:25:54 Column Name parameter problem