Weird function behavior from Sept 11 snapshot

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

Responses

Browse pgsql-hackers by date

  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