Re: [HACKERS] regproc's lack of certainty is dangerous

2003-03-22 Thread Tom Lane
I wrote: >> I think that we can actually get away (from an implementation point of >> view) with a column containing arrays of different base types; array_out >> will still work AFAIR. It's an interesting question though how such a >> column could reasonably be declared. This ties into your recen

Re: [HACKERS] regproc's lack of certainty is dangerous

2003-03-12 Thread Joe Conway
Tom Lane wrote: I think that we can actually get away (from an implementation point of view) with a column containing arrays of different base types; array_out will still work AFAIR. It's an interesting question though how such a column could reasonably be declared. This ties into your recent inv

Re: [HACKERS] regproc's lack of certainty is dangerous

2003-03-12 Thread Joe Conway
Tom Lane wrote: I think that we can actually get away (from an implementation point of view) with a column containing arrays of different base types; array_out will still work AFAIR. It's an interesting question though how such a column could reasonably be declared. This ties into your recent inv

Re: [HACKERS] regproc's lack of certainty is dangerous

2003-03-12 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I am not sure what to do about columns that >> have datatypes without matching array types, though (that would include >> array columns and domains, IIRC). Maybe use array of bytea to hold the >> internal representation of the type? > IS

Re: [HACKERS] regproc's lack of certainty is dangerous

2003-03-12 Thread Joe Conway
Tom Lane wrote: Another approach is to try to fix pg_statistic to avoid the problem by not doing I/O conversions. For scalar datatypes (those that have associated array types) it'd be probably be feasible to store the histogram and most-common-value arrays as arrays of the datatype itself, not arr