| From: | Ragnar Hafstað <gnari(at)simnet(dot)is> |
|---|---|
| To: | "FERREIRA William (COFRAMI)" <william(dot)ferreira(at)airbus(dot)com> |
| Cc: | 'Richard Huxton' <dev(at)archonet(dot)com>, "GIROIRE Nicolas (COFRAMI)" <nicolas(dot)giroire(at)airbus(dot)com>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Convert Cursor to array |
| Date: | 2005-03-14 11:10:36 |
| Message-ID: | 1110798636.24917.22.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Janning Vygen | 2005-03-14 11:16:48 | pg_restore: [custom archiver] could not uncompress data: incorrect data check |
| Previous Message | Alejandro D. Burne | 2005-03-14 10:32:46 | Re: Temporary tables privileges |