Re: Does Postgresql have a similar pseudo-column "ROWNUM" as - Mailing list pgsql-sql

On Fri, 2005-05-20 at 13:27, Keith Worthington wrote:

> Scott,
> 
> I realize that this thread went off in another direction however your
> suggestion proved very helpful for a problem that I was trying to solve.  I
> wanted the row number of a set returned by a function.  Here is a chopped
> version of the function that I wrote.
> 
> CREATE OR REPLACE FUNCTION func_bom(integer, integer)
>   RETURNS SETOF func_bom AS

SNIP

> Although I have no need to limit the output I tried it just for giggles and it
> worked fine.
> 
> SELECT * FROM func_bom(12345, 1) WHERE subline between 4 AND 6;

You're welcome.  I've saved that off to my ~/pgsql directory for future
use.  So, the thanks are back to you. :)