Search Postgresql Archives

Re: fastes way to retrieve segmented without using loop

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Correction:

SELECT  DISTINCT ON EXTRACT(HOUR FROM you_time_column)
                *
  FROM table
WHERE  t >=1
LIMIT  99998;

On Sun, Aug 23, 2015 at 5:38 PM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote:
Well, I would say the following might work:

SELECT  *
  FROM table
WHERE  t >=1
LIMIT  99998;

On Sun, Aug 23, 2015 at 5:05 PM, Tom Smith <tomsmith1989sk@xxxxxxxxx> wrote:
Hello:

I have a time series table,
using below sql, loop (psque code), I can get one row for each hour

for( H=1: H< 99999; H++){
   select  * from table where  t >= H and t < H+1   limit 1
}

t (time column) is indexed).

Is there a better way to use a issue a SINGLE SQL
with  an array of time start/end pair
so it will be executed once to send back result, which would be much faster
than issuing sql again and again (even with prepared statement and using sql function).

Thanks in Advance



--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.




--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux