[SQL] Limit clause is not working in Postgresql7.0.2

[Ricky]

 
  Hi all  ,

I tried to do a select statement below :

select * from homeuser order userid 
limit 5;

   However it did not working ,it display all the records in the
database.
   You all have any ideas how to use limit clause ??

   Thanks weetat

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] Counting Row

[Ricky Sutanto]

 

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,

 

[SQL] Counting Row

[Ricky Sutanto]

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,

 

[SQL] Performance issue

[Ricky Sutanto]

I use Apache Web Server and PostgreSQL 7.3 to collect data everyday. Now it
has been 5 month since I install that server. 

I wonder why now my web very slow to retrieve and display data? 
When I check the memory, I found that postgreSQL client seem not release
after allocate. I try to find bug on my script, but everything look clean to
me. 

Anyone have experience like me.. please share info with me

Thanks anyway, 


Ricky Sutanto



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

[SQL] Performance issue

[Ricky Sutanto]

I use Apache Web Server and PostgreSQL 7.3 to collect data everyday. Now it
has been 5 month since I install that server. 

I wonder why now my web very slow to retrieve and display data? 
When I check the memory, I found that postgreSQL client seem not release
after allocate. I try to find bug on my script, but everything look clean to
me. 

Anyone have experience like me.. please share info with me

Thanks anyway, 


Ricky Sutanto



---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

[SQL] unsubscribe

[Ricky Sutanto]

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

[SQL] unsubscribe

[Ricky Sutanto]

Please unsubscribe me