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
Cc: Nabil Aziz Sawaya <nabilsawaya@gmail.com>
Subject: Re: reg:Query
Date: Tue, 16 May 2006 18:42:21 +0530
Message-ID: <03f701c678ea$5e1124a0$cd00000a@sandhyar> (raw)
References: <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAAC4AAAAAAAAAt+qV6pqKPEmXG74T lFgX5gEAlpDSN+DrMEWnumhoRHpQKQAAAbLc9wAAEAAAAKaDNzHBbxlMnMLstafXD+sBAAAAAA= =@mailnetwork.co.uk>

Thank you.....
  ----- Original Message ----- 
  From: Andy Shellam 
  To: 'sandhya' 
  Cc: pgsql-admin@postgresql.org 
  Sent: Tuesday, May 16, 2006 6:26 PM
  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,4469ca6434491997014324! 

view thread (10+ messages)  latest in thread

Message-ID: <03f701c678ea$5e1124a0$cd00000a@sandhyar>
Permalink:  ../03f701c678ea$5e1124a0$cd00000a@sandhyar/
Also on:    postgresql.org/message-id/03f701c678ea$5e1124a0$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, nabilsawaya@gmail.com
  Subject: Re: reg:Query
  In-Reply-To: <03f701c678ea$5e1124a0$cd00000a@sandhyar>
  References: <03f701c678ea$5e1124a0$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