Re: Collations versus user-defined functions

On sön, 2011-03-13 at 13:16 -0400, Tom Lane wrote:
> Well, it's exactly that distinction that's bugging me.  It seems a bit
> arbitrary if collation propagates in certain cases where collation
> state doesn't.  I'm concerned in particular that we're going to find
> ourselves backend into a corner if someone comes up with a different
> reading of the spec.  The proposed implementation will be incapable of
> propagating collation state across subselect boundaries (because the
> post-parse scan is going to operate at most one subquery at a time),
> so if someone convinces us that we should do that, what then?

Do you have an example of what you have in mind?

There are some cases in the SQL standard that the current implementation
doesn't cover yet.  But then again, we have also moved the type system
around a few times over the years as we have gained experience and found
the time to write the code.