Re: reg:Query

"sandhya" <sandhyar@xxxxxxxxxxxxxx> · Tue, 16 May 2006 18:58:28 +0530

yes..I got it.
SELECT .................... LIMIT x OFFSET y.Am i 
right?

  ----- Original Message ----- 
  From: 
  Andy Shellam 
  To: 'sandhya' 
  Cc: pgsql-admin@xxxxxxxxxxxxxx 
  Sent: Tuesday, May 16, 2006 6:35 PM
  Subject: FW: [ADMIN] reg:Query

  Actually, just 
  realized, this depends on your PGSQL version.  

  The older format 
  (pre-8.0 I believe) is SELECT ?.. LIMIT x, y  (where x is the number of 
  rows to fetch, and y is the offset (ie. Select x number of rows, starting from 
  row y.)

  Andy

  From: pgsql-admin-owner@xxxxxxxxxxxxxx 
  [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Andy Shellam
Sent: 16 May 2006 1:57 pm
To: 'sandhya'
Cc: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: [ADMIN] 
  reg:Query

  SELECT ?.. LIMIT 
  1

  Will get the first 
  row in the dataset.  Then to fetch the next row, you can do SELECT ?? 
  LIMIT 1 OFFSET 1 (will get the 2^nd record) and so 
  on.
  (replace ?.. with 
  your conditions, LIMIT must come at the end of the 
  query)

  Andy

  From: 
  pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] 
  On Behalf Of sandhya
Sent: 16 May 2006 11:47 am
To: Postgres
Cc: sandhya
Subject: [ADMIN] 
  reg:Query

  Hi

   Is there any query for possibility of getting 
  only one row at a time in a group of 
  records?

  With distinct rows & Columns my query has to 
  return only one record at a time with out any condition.Will it be 
  possible?

  Thank you,

  Sandhya

  !DSPAM:14,4469cd4d34491667573013! 