Re: RETURN NEXT and reversing order - Mailing list pgsql-general

From Richard Huxton
Subject Re: RETURN NEXT and reversing order
Date
Msg-id 200402040953.13664.dev@archonet.com
Whole thread Raw
In response to RETURN NEXT and reversing order  (CSN <cool_screen_name90001@yahoo.com>)
List 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

pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Transfer database tables to a schema
Next
From: Christian Traber
Date:
Subject: Transaction end on error