From: Pascual De Ruvo <deruvo@gmail.com>
To: ricky@connexiasolutions.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Counting Row
Date: Sun, 24 Jul 2005 18:07:09 -0400
Message-ID: <fb73c1ee050724150758597439@mail.gmail.com> (raw)
In-Reply-To: <20050722031154.CBBCD5284E@svr1.postgresql.org>
References: <20050722031154.CBBCD5284E@svr1.postgresql.org>
I understand you need to count of tickets smaller than $recid given
[CONDITION], in that case:
$sql="select count(*) from [MYTABLE] where [CONDITION] and ticketnumber <="
.$recid ;
On 7/21/05, Ricky Sutanto <ricky@connexiasolutions.com> wrote:
>
> 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,*
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: deruvo@gmail.com, ricky@connexiasolutions.com
Subject: Re: Counting Row
In-Reply-To: <fb73c1ee050724150758597439@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox