pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: sandhya <sandhyar@amiindia.co.in>
To: andy.shellam@mailnetwork.co.uk
Cc: pgsql-admin@postgresql.org
Subject: Re: reg:Query
Date: Tue, 16 May 2006 18:58:28 +0530
Message-ID: <040c01c678ec$9ef243d0$cd00000a@sandhyar> (raw)
References: <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAAC4AAAAAAAAAt+qV6pqKPEmXG74T lFgX5gEAlpDSN+DrMEWnumhoRHpQKQAAAbLc9wAAEAAAABbZZZcyWK9Gh5zBvUODuY0BAAAAAA= =@mailnetwork.co.uk>

yes..I got it.
SELECT .................... LIMIT x OFFSET y.Am i right?
  ----- Original Message ----- 
  From: Andy Shellam 
  To: 'sandhya' 
  Cc: pgsql-admin@postgresql.org 
  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@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Andy Shellam
  Sent: 16 May 2006 1:57 pm
  To: 'sandhya'
  Cc: pgsql-admin@postgresql.org
  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 2nd record) and so on.

  (replace ... with your conditions, LIMIT must come at the end of the query)

   

  Andy

   


------------------------------------------------------------------------------

  From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] 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! 

view thread (10+ messages)  latest in thread

Message-ID: <040c01c678ec$9ef243d0$cd00000a@sandhyar>
Permalink:  ../040c01c678ec$9ef243d0$cd00000a@sandhyar/
Also on:    postgresql.org/message-id/040c01c678ec$9ef243d0$cd00000a@sandhyar

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: sandhyar@amiindia.co.in, andy.shellam@mailnetwork.co.uk
  Subject: Re: reg:Query
  In-Reply-To: <040c01c678ec$9ef243d0$cd00000a@sandhyar>
  References: <040c01c678ec$9ef243d0$cd00000a@sandhyar>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox