Re: Simulate count result are distinct between 8.3 and 8.4

From: Emanuel Calvo Franco <postgres(dot)arg(at)gmail(dot)com>
To: Shoaib Mir <shoaibmir(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Simulate count result are distinct between 8.3 and 8.4
Date: 2009-08-13 17:53:18
Message-ID: f205bb120908131053k407e3ff9j48029ccc944c08f6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> Why don't you make it simple and just use row_number() from 8.4... It can be
> simplified as:
>
> select row_number() over(), i, p from prueba limit 5;
>

I know the use of WF. What surprised me, is the difference between
both versions in the same query. I'm trying to understand why happens
and not look for another way :)

--
Emanuel Calvo Franco
Database consultant at:
www.siu.edu.ar
www.emanuelcalvofranco.com.ar

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shane Ambler 2009-08-13 18:23:37 Re: PostgreSQL for Firefox Bookmarks?
Previous Message Sam Mason 2009-08-13 17:36:55 Re: Selecting rows by content of array type field