From: | "FERREIRA William (COFRAMI)" <william(dot)ferreira(at)airbus(dot)com> |
---|---|
To: | 'Ragnar Hafstað' <gnari(at)simnet(dot)is> |
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 15:17:05 |
Message-ID: | 1904E3EB39448246A7ECB76DF34A70B00143B484@TOCOMEXC03 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
well my example was incomplete :
at the begin :
chapter_id | evolution | index
1 | 0 | 1
2 | 0 | 2
3 | 0 | 3
4 | 1 | 2
5 | 1 | 4
by using the sort function i obtain this :
chapter_id | evolution | index
1 | 0 | 1
4 | 1 | 2
2 | 0 | 2
5 | 1 | 4
3 | 0 | 3
that why i can't use ORDER BY...
-----Message d'origine-----
De : Ragnar Hafstað [mailto:gnari(at)simnet(dot)is]
Envoyé : lundi 14 mars 2005 12:11
À : FERREIRA William (COFRAMI)
Cc : 'Richard Huxton'; GIROIRE Nicolas (COFRAMI);
'pgsql-general(at)postgresql(dot)org'
Objet : Re: [GENERAL] Convert Cursor to array
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
This mail has originated outside your organization,
either from an external partner or the Global Internet.
Keep this in mind if you answer this message.
From | Date | Subject | |
---|---|---|---|
Next Message | Rick Schumeyer | 2005-03-14 15:43:25 | Re: prelimiary performance comparison pgsql vs mysql |
Previous Message | Shachar Shemesh | 2005-03-14 14:44:25 | Re: skip weekends: revisited |