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

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 ---

[SQL] Counting Row

  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

[SQL] Counting Row

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 wit

[SQL] Performance issue

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

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

[SQL] unsubscribe

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

[SQL] unsubscribe

Please unsubscribe me