[SQL] Crosstab function

2005-04-05 Thread bandeng
hello guys, I want to use crosstab function but that function it doesnt exist. my version is 7.3 so how do i get the tablefunc.sql from postgre contrib? i saw in ver 8 win32 is checkable. Thanks Ricky -- Gutten Aben Sugeng Sonten, Jangane Kurang Santen bandeng -

Re: [SQL] Speed up slow select - was gone blind

2005-04-05 Thread Gary Stainburn
Hi folks. I did send an explain analyze last week but for some reason it didn't appear on the list. However, I've looked into the delay and it doesn't seem to be the SQL. I'm now looking into why my PHP seems to sit there for 20+ seconds doing nowt. Thanks to everyone for the help anyway. G