[SQL] array handling on 8.0.3

2007-10-09 Thread Daniel Drotos
Hi, I have to run a function on a 9.0.3 server. Following part (of a bigger function): create or replace function t(p varchar) returns void as $$ declare v varchar; f varchar; a varchar[]; i integer; begin a:= '{}'; if p like '%/%' then v:= trim_null(spl

Re: [SQL] finding unused indexes?

2007-10-09 Thread George Pavlov
resurrecting an old thread: so is it safe to say that an index that has pg_stat_user_indexes.idx_scan, pg_stat_user_indexes.idx_tup_read, and pg_stat_user_indexes.idx_tup_fetch all equal to 0 has not been used (since stats have been reset)? i have a bunch of those and all of them have pg_statio_u

Re: [SQL] array handling on 8.0.3

2007-10-09 Thread Daniel Drotos
On Tue, 9 Oct 2007, Daniel Drotos wrote: I have to run a function on a 9.0.3 server. Following part (of a bigger ^ I mean 8.0.3 sorry Daniel ---(end of broadcast)--- TIP 6: explain analyze

Re: [SQL] array handling on 8.0.3

2007-10-09 Thread Daniel Drotos
Hi, I found my bug, please forget my (stupid) question! Daniel ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings