query based on row number for psql8.3 - Mailing list pgsql-sql

From Emi
Subject query based on row number for psql8.3
Date
Msg-id 56F2D9C4.9010304@encs.concordia.ca
Whole thread Raw
Responses Re: query based on row number for psql8.3
Re: query based on row number for psql8.3
Re: query based on row number for psql8.3
List pgsql-sql
Hello,

For psql8.3, is there a simple way to query based on row number please?

For example,

select  case                    when row_num=1 THEN    t1.tot_hr                    ELSE
 t1.tot_hr - 
 
t1.pre_hr          END
FROM  t1 ;






pgsql-sql by date:

Previous
From: Igor Neyman
Date:
Subject: Re: simple function index question
Next
From: Adrian Klaver
Date:
Subject: Re: query based on row number for psql8.3