Ok, thanks ^^ Cheers, Rémi-C
2014-02-06 Vik Fearing <vik.fear...@dalibo.com>: > 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 > >