Reply-To: emilu@encs.concordia.ca
To: pgsql-sql@postgresql.org
From: Emi <emilu@encs.concordia.ca>
Subject: query based on row number for psql8.3
Message-ID: <56F2D9C4.9010304@encs.concordia.ca>
Date: Wed, 23 Mar 2016 14:00:36 -0400
User-Agent: Mozilla/5.0 (X11; Linux i686 on x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.6.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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 ;


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql