Re: How to implement oracle like rownum(function or seudocolumn)

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "David Fetter" <david(at)fetter(dot)org>
Cc: "Jan Wieck" <JanWieck(at)yahoo(dot)com>, "Michael Fuhr" <mike(at)fuhr(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Juan Manuel Diaz Lara" <jmdiazlr(at)yahoo(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to implement oracle like rownum(function or seudocolumn)
Date: 2006-04-08 22:26:33
Message-ID: 36e682920604081526s5f5129cem9369c51672d3af1f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 4/8/06, David Fetter <david(at)fetter(dot)org> wrote:
> Sadly, ANSI did just that.

Thanks for pointing that out... I'd been using LIMIT/OFFSET for so
long, I totally forgot about the standard :(

--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Maxwell 2006-04-09 00:43:07 Re: Support Parallel Query Execution in Executor
Previous Message Jonah H. Harris 2006-04-08 22:21:38 Re: Support Parallel Query Execution in Executor