From: | Mike Mascari <mascarm(at)mascari(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Weird function behavior from Sept 11 snapshot |
Date: | 2000-09-12 11:06:28 |
Message-ID: | 39BE0E34.666FE437@mascari.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Under both 6.5 and 7.0:
----------------------
stocks=# create table test (key int4);
CREATE
stocks=# create function crap(int4) returns int4 as
'select sum(key) from test' language 'sql';
CREATE
stocks=# select version();
version
---------------------------------------------------------------------
PostgreSQL 7.0.0 on i686-pc-linux-gnu, compiled by gcc
egcs-2.91.66
Under the snapshot from yesterday:
---------------------------------
template1=# create table test (key int4);
CREATE
template1=# create function crap(int4) returns int4
as 'select sum(key) from test' language 'sql';
ERROR: return type mismatch in function: declared to return
int4, returns numeric
template1=# select version();
version
------------------------------------------------------------------------
PostgreSQL 7.1devel on i586-pc-linux-gnu, compiled by GCC
egcs-2.91.66
Is this correct behavior? All of the regression tests pass on the
snapshot version, BTW.
Mike Mascari
From | Date | Subject | |
---|---|---|---|
Next Message | Valter Mazzola | 2000-09-12 11:27:11 | Re: Patch for TNS services |
Previous Message | Mike Mascari | 2000-09-12 10:03:43 | Re: FYI - Build problems when an RPM version is installed |