Re: query based on row number for psql8.3

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: query based on row number for psql8.3
Date: 2016-03-23 18:26:36
Message-ID: 56F2DFDC.2020408@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 03/23/2016 12:00 PM, Emi wrote:
> 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 ;
>
>
>
>
>
I seem to recall other posts from condordia: Someone needs to take of
their skates and update postgres!

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephen Tahmosh 2016-03-23 18:57:30 Re: query based on row number for psql8.3
Previous Message Adrian Klaver 2016-03-23 18:17:50 Re: query based on row number for psql8.3