Re: [HACKERS] create function bug?

From: Brett McCormick <brett(at)work(dot)chicken(dot)org>
To: Ewan Mellor <em(at)nexus(dot)co(dot)uk>
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] create function bug?
Date: 1998-02-05 19:05:19
Message-ID: 199802051905.LAA00048@abraxas.scene.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-02-05 19:08:12 atttypmod problem
Previous Message Bruce Momjian 1998-02-05 19:00:53 Re: atttypmod is wrong in system catalogs