Implicit casts with generic arrays - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Implicit casts with generic arrays
Date
Msg-id 200702271905.42407.peter_e@gmx.net
Whole thread Raw
Responses Re: Implicit casts with generic arrays  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I've looked into cutting back on the implicit casts to text, which 
exposed the following little gem.

The expressions

'abc' || 34
34 || 'abc'

would no longer work, with the following error message:

ERROR:  22P02: array value must start with "{" or dimension information

That's because the best matches are now respectively

anyarray || anyelement
anyelement || anyarray

Now either this is just too bad and users of a system with reduced casts 
to text will have to live with this odd error message, or coercing any 
old unknown constant to anyarray isn't such a good idea.

Comments?

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: COMMIT NOWAIT Performance Option
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Seeking Google SoC Mentors