I tried that and it does indeed work. (With, of course, the appropriate permissions to create the cast.)So this makes me wonder--is there any downside or unwelcome side effects to having such a cast? And if not, why isn't it part of the default setup?
By and large implicit casts work great if you code everything without error. When they become a problem is when you make mistakes and because of implicit casting instead of getting an error you get bogus results.
David J.
View this message in context: Re: Array string casts with SELECT but not SELECT DISTINCT
Sent from the PostgreSQL - general mailing list archive at Nabble.com.