Re: [HACKERS] Make CREATE AGGREGATE check validity of initcond value?

2012-10-04 Thread Jaime Casanova
El 03/10/2012 21:38, "Tom Lane" escribió: > > Does anyone have an objection to this? I can imagine cases where the > check would reject values that would get accepted at runtime, if the > type's input function was sensitive to the phase of the moon or > something. But it doesn't seem very probab

[HACKERS] Make CREATE AGGREGATE check validity of initcond value?

2012-10-03 Thread Tom Lane
In http://archives.postgresql.org/pgsql-general/2012-10/msg00138.php we see an example where a user tried to create an aggregate whose "initcond" (initial transition value) wasn't valid for the transition data type. CREATE AGGREGATE didn't complain because it just stores the initial condition as a