Re: Collations versus user-defined functions

On 12.03.2011 18:17, Tom Lane wrote:
>    Does the SQL
> standard have anything to say on the matter, or is there a precedent in
> the behavior of TSQL or other DBMSes?

Tom,

SQL standard let it open for implementers.

The other DBMS - for which I am/was collation expert - takes afair the
database/schema collation for functions/procedures - no individual 
collation.

Just believe me - there is tons of user complain feedback on this
topic. I really can't recommend doing it same way. My experience
is that users want to use own collations in functions too.

Susanne

-- 
Susanne Ebrecht - 2ndQuadrant
PostgreSQL Development, 24x7 Support, Training and Services
www.2ndQuadrant.com