Re: [BUGS] Oddities with ANYARRAY

2007-08-01 Thread Gregory Stark
"Decibel!" <[EMAIL PROTECTED]> writes: > David Fetter and I were just looking at something on IRC... > > decibel=# select most_common_vals[1] from pg_stats where > tablename='pg_depend' and attname='classid'; > ERROR: cannot subscript type anyarray because it is not an array > decibel=# select m

[BUGS] BUG #3503: Benchmark scripts broken

2007-08-01 Thread Justin Hibbits
The following bug has been logged online: Bug reference: 3503 Logged by: Justin Hibbits Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux Description:Benchmark scripts broken Details: It appears that the benchmark script src/test/ben

Re: [BUGS] EXPLAIN ANALYZE for bitmapAnd and bitmapOr scans always reports rows = 0

2007-08-01 Thread Heikki Linnakangas
Joseph S wrote: > From this snipped you can see that the Bitmap Heap scan returns 123 > rows, but the BitmapAnd under it returns 0. I would find it useful to > determine how many rows were thrown out by the recheck. Yeah, it would be nice. Unfortunately there's some problems with that, see previo

Re: [BUGS] Oddities with ANYARRAY

2007-08-01 Thread Decibel!
On Jul 31, 2007, at 11:55 PM, Gregory Stark wrote: "Decibel!" <[EMAIL PROTECTED]> writes: David Fetter and I were just looking at something on IRC... decibel=# select most_common_vals[1] from pg_stats where tablename='pg_depend' and attname='classid'; ERROR: cannot subscript type anyarray

Re: [BUGS] BUG #3503: Benchmark scripts broken

2007-08-01 Thread Bruce Momjian
Justin Hibbits wrote: > > The following bug has been logged online: > > Bug reference: 3503 > Logged by: Justin Hibbits > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.4 > Operating system: Linux > Description:Benchmark scripts broken > Details: > > It

Re: [BUGS] Oddities with ANYARRAY

2007-08-01 Thread Gregory Stark
"Decibel!" <[EMAIL PROTECTED]> writes: > On Jul 31, 2007, at 11:55 PM, Gregory Stark wrote: >> >> And what type would the result be? > > ANYELEMENT? I know that'd still have to be casted to something normal > eventually; do we have support for that? There isn't really any such thing. There isn't