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

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

[SQL] Crosstab function

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 -