I noticed that too, but since I don't use 'integer' in tables, I
figured postgres didn't have the "integer" type (which probably should
have struck me as odd). It might be one of these silly grammer
rewrites, in which case (if there isn't central type/function parsing
code it seems like more trouble than it's worth, I mean why not just
have the extra type/functions in the catalogs? or have aliases somehow?)
I'm sure you can work around it ;)
On Thu, 5 February 1998, at 17:00:15, Ewan Mellor wrote:
> Using a snapshot from two days ago on a i586-pc-linux-gnu using
> linux-elf template:
>
> test=> create table test (t1 integer);
> CREATE
> test=> create function myfunc (integer) returns integer
> test-> as 'select $1' language 'sql';
> ERROR: ProcedureCreate: arg type 'integer' is not defined
> test=> create function myfunc(int4) returns int4
> test-> as 'select $1' language 'sql';
> CREATE
>
> I can use the integer type in tables, but not in functions. Is this a
> bug?
>
> Ewan Mellor.