Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Hi postgre people. Can anybody help to fix performance of my query? Let say, I have n number of queue ticket. (Which I use SELECT).Is there faster method to know where is my ticket number in queue? I use (while in PHP script ) and count one by one until my ticket number match with row field . $sql="select * from [MYTABLE] where [CONDITION] order by [FIELDORDER];$rs=&$ctclink->Execute($sql);$ctr=1;$pos=0; while (!$rs->EOF) { if ($rs->fields[0]==$recid) { $pos=$ctr; break; } else { $ctr++; $rs->MoveNext(); } } print $pos is there any method to do that with simple?? Thanks,
Hi postgre people. Can anybody help to fix performance of my query?
Let say, I have n number of queue ticket. (Which I use SELECT).
Is there faster method to know where is my ticket number in queue?
I use (while in PHP script ) and count one by one until my ticket number match with row field .
$sql="select * from [MYTABLE] where [CONDITION] order by [FIELDORDER];
$rs=&$ctclink->Execute($sql);
$ctr=1;
$pos=0;
while (!$rs->EOF) {
if ($rs->fields[0]==$recid) {
$pos=$ctr;
break;
} else {
$ctr++;
$rs->MoveNext(); }
}
print $pos
is there any method to do that with simple??
Thanks,
В списке pgsql-sql по дате отправления: