| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | Clemens Eisserer <linuxhippy(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Howto only select secific lines from a result? |
| Date: | 2010-08-08 09:07:44 |
| Message-ID: | 45179171-87C5-4F8C-86B4-4C29B4AB4A5F@solfertje.student.utwente.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 8 Aug 2010, at 3:37, Clemens Eisserer wrote:
> What I would need is a LIMIT command, which allows to LIMIT the
> results in two ways.
> Is there some way to select only specific lines from a result, something like:
> Select * from table Where RESULNR BETWEEN 1000 and 1040?
>
> Or do you have any other ideas howto solve this problem?
I think cursors are what you're looking for. Start reading from: http://www.postgresql.org/docs/8.4/interactive/sql-declare.html
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,4c5e73eb286211213419466!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Torsten Zühlsdorff | 2010-08-08 09:45:05 | Re: MySQL versus Postgres |
| Previous Message | Thomas Kellerer | 2010-08-08 09:01:21 | Re: Using AND in query |