Re: RETURN NEXT and reversing order

From: Richard Huxton <dev(at)archonet(dot)com>
To: CSN <cool_screen_name90001(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: RETURN NEXT and reversing order
Date: 2004-02-04 09:53:13
Message-ID: 200402040953.13664.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 04 February 2004 06:24, CSN wrote:
> Is it possible to reverse the order of items returned
> from a plpgaql function that uses RETURN NEXT? (order
> by col isn't what I want)
>
> select * from my_function();

I don't think ORDER BY can operate without a column to refer to. Looks like
you'll need a parameter on the function so it runs itself backwards.
--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christian Traber 2004-02-04 09:54:35 Transaction end on error
Previous Message Shridhar Daithankar 2004-02-04 08:18:52 Re: Transfer database tables to a schema