Re: Ordering Results by a Supplied Order - Mailing list pgsql-general

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