On Thu, Aug 02, 2007 at 12:44:02AM +0100, Gregory Stark wrote:
>
> "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
> > eventua
"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
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
"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
Decibel! wrote:
> 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 most_common_freqs[1] fro
Decibel! <[EMAIL PROTECTED]> writes:
> ISTM you'd want to be able to reference an individual element of an
> ANYARRAY...
And what type would the result have?
pg_statistic is definitely pushing the boundaries of the type system
by having an anyarray column. We don't allow that in normal user
tabl
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 most_common_freqs[1] from pg_stats where tablename='