Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
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@gmail.com> wrote:Hello:I have a time series table,using below sql, loop (psque code), I can get one row for each hourfor( 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 pairso it will be executed once to send back result, which would be much fasterthan issuing sql again and again (even with prepared statement and using sql function).Thanks in Advance-- Melvin DavidsonI reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
Hello:I have a time series table,using below sql, loop (psque code), I can get one row for each hourfor( 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 pairso it will be executed once to send back result, which would be much fasterthan issuing sql again and again (even with prepared statement and using sql function).Thanks in Advance
В списке pgsql-general по дате отправления: