Postgres Pro
Downloads
Home   >   mailing lists

Re: Transition functions for SUM(::int2), SUM(::int4, SUM(::int8]) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Transition functions for SUM(::int2), SUM(::int4, SUM(::int8])
Date
Msg-id 11781.1201577518@sss.pgh.pa.us
Whole thread Raw
In response to Transition functions for SUM(::int2), SUM(::int4, SUM(::int8])  (Caleb Welton <cwelton@greenplum.com>)
Responses Re: Transition functions for SUM(::int2), SUM(::int4, SUM(::int8])  (Caleb Welton <cwelton@greenplum.com>)
List pgsql-hackers
Tree view 
Caleb Welton <cwelton@greenplum.com> writes:
> Is there any reason that int2_sum, int4_sum, and int8_sum are not marked as
> being strict?

They wouldn't work otherwise, because the transition datatypes aren't
the same as the inputs.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Caleb Welton
Date:
Subject: Transition functions for SUM(::int2), SUM(::int4, SUM(::int8])
Next
From: Hans-Juergen Schoenig
Date:
Subject: Re: autonomous transactions