| From: | Phil Meadway <philip(dot)meadway(at)esmltd(dot)co(dot)uk> |
|---|---|
| To: | Boszormenyi Laszlo <gcs(at)jupiter(dot)hlab(dot)uni-miskolc(dot)hu> |
| Cc: | pgsql-novice(at)hub(dot)org |
| Subject: | Re: Get a row by it's number |
| Date: | 2000-07-20 10:59:49 |
| Message-ID: | 3976DBA4.E702D8A9@esmltd.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
By definition, relation database tables are unordered. This is because the
storage characteristics can change (say from ISAM to BTREE or HASH indexing)
without affecting the data content. Do you want to retrieve the nth row from
a select ... order by statement? Or are you looking for the nth row added? Nth
row added can be achieved if you use an incrementing sequence counter when
adding.
Boszormenyi Laszlo wrote:
> Hello!
>
> Is there any way to execute a select, and get only a specified row (let's
> say the third one)?
>
> Thanks in advance,
> Laszlo Boszormenyi
--
Phil Meadway Tel.: +(44) 1444 892 274
Managing Director philip(dot)meadway(at)esmltd(dot)co(dot)uk
Enterprise Systems Management Limited www.esmltd.co.uk
| Attachment | Content-Type | Size |
|---|---|---|
| philip.meadway.vcf | text/x-vcard | 377 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew McMillan | 2000-07-20 11:21:32 | Re: Get a row by it's number |
| Previous Message | Boszormenyi Laszlo | 2000-07-20 10:54:22 | Get a row by it's number |