Re: [GENERAL] analyze-error: "cannot compare arrays of different element types" revisited

2004-12-17 Thread Tom Lane
"Florian G. Pflug" <[EMAIL PROTECTED]> writes: > Since postgres disallows empty array literals (array[] gives an syntax > error), I guess creating empty array by removing the last element is > quite hackish too... Will empty arrays be eventually supported, or will > they be forbidden entirely (e.g,

Re: [GENERAL] analyze-error: "cannot compare arrays of different element types" revisited

2004-12-17 Thread Tom Lane
"Florian G. Pflug" <[EMAIL PROTECTED]> writes: > A few weeks ago, I reported that ANALYZE gives the error > "cannot compare arrays of different element types" > in one of my databases. > I now constructed a small testcase that is able to reproduce the problem: Thanks for the example. It turns ou

Re: [GENERAL] analyze-error: "cannot compare arrays of different

2004-12-17 Thread Florian G. Pflug
Florian G. Pflug wrote: A few weeks ago, I reported that ANALYZE gives the error "cannot compare arrays of different element types" in one of my databases. I now constructed a small testcase that is able to reproduce the problem: -

[GENERAL] analyze-error: "cannot compare arrays of different element types" revisited

2004-12-17 Thread Florian G. Pflug
Hi A few weeks ago, I reported that ANALYZE gives the error "cannot compare arrays of different element types" in one of my databases. I now constructed a small testcase that is able to reproduce the problem: --- -- The databa