Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow query: select * order by XXX desc offset 10 limit 10 - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Slow query: select * order by XXX desc offset 10 limit 10
Date
Msg-id CAFj8pRA4Xy2XypoX=tfF-wsW0xvtXaEbPNKEcUx68K3V+4iA6w@mail.gmail.com
Whole thread Raw
In response to Re: Slow query: select * order by XXX desc offset 10 limit 10  (Alexander Farber <alexander.farber@gmail.com>)
Responses Re: Slow query: select * order by XXX desc offset 10 limit 10  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view 
Hello

you should to use a DECLARE statement

http://www.postgresql.org/docs/9.1/interactive/sql-declare.html

and fetch statement

http://www.postgresql.org/docs/9.1/interactive/sql-fetch.html

Regards

Pavel Stehule


2011/10/14 Alexander Farber <alexander.farber@gmail.com>:
> I've also tried opening cursor:
>
> quincy=> open ref for select to_char(qdatetime, 'YYYY-MM-DD') as
> QDATETIME,ID,NAME,CATEGORY,APPSVERSION,OSVERSION,DETAILS,DEVINFO from
> quincyview where qdatetime <= now() order by QDATETIME desc ;
> ERROR:  syntax error at or near "open"
> LINE 1: open ref for select to_char(qdatetime, 'YYYY-MM-DD') as QDAT...
>        ^
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: Slow query: select * order by XXX desc offset 10 limit 10
Next
From: Alexander Farber
Date:
Subject: Re: Slow query: select * order by XXX desc offset 10 limit 10