Re: Convert Cursor to array - Mailing list pgsql-general

From Ragnar Hafstað
Subject Re: Convert Cursor to array
Date
Msg-id 1110798636.24917.22.camel@localhost.localdomain
Whole thread Raw
In response to Re: Convert Cursor to array  ("FERREIRA William (COFRAMI)" <william.ferreira@airbus.com>)
List pgsql-general
On Mon, 2005-03-14 at 10:44 +0100, FERREIRA William (COFRAMI) wrote:

> so we choice to use a different solution which consist on using the
> index of a chapter and its evolution.
> if we have this data :
> chapter_id | evolution | index
>    1       |     0     |   1
>    2       |     0     |   2
>    3       |     0     |   3
>    4       |     1     |   2
>
> by using our sort function we obtain this :
> chapter_id | evolution | index
>    1       |     0     |   1
>    4       |     1     |   2
>    2       |     0     |   2
>    3       |     0     |   3
>

in what way is this different than
  ... ORDER BY index ASC, evolution DESC;
?

gnari



pgsql-general by date:

Previous
From: "Alejandro D. Burne"
Date:
Subject: Re: Temporary tables privileges
Next
From: Janning Vygen
Date:
Subject: pg_restore: [custom archiver] could not uncompress data: incorrect data check