Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group