Re: Ordering Results by a Supplied Order

[Rémi Cura <remi.cura@xxxxxxxxx>]

Ok, thanks ^^

Cheers,
Rémi-C

2014-02-06 Vik Fearing <vik.fearing@xxxxxxxxxx>:

On 02/06/2014 10:00 AM, Rémi Cura wrote:
> Hey,
>  I don"t understand the difference between this ORDINALITY option and
> adding a "row_number() over()" in the SELECT.

WITH ORDINALITY will give you something to order by.  You should never
do "row_number() over ()" because that will give you potentially random
results.

--
Vik