Re: BUG #3116: attribute has wrong type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3116: attribute has wrong type
Date: 2007-03-06 18:21:46
Message-ID: 6798.1173205306@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Greg Sabino Mullane" <greg(at)turnstep(dot)com> writes:
> CREATE OR REPLACE FUNCTION gregtest(int) RETURNS varchar
> LANGUAGE sql AS $$ SELECT 'abc'::text; $$;

Hm, I'd argue that that should be rejected. SQL functions currently
demand exact match between the declared return type and their final
SELECT command ... wonder why this case is getting past?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-03-06 18:33:12 Re: BUG #3116: attribute has wrong type
Previous Message Greg Sabino Mullane 2007-03-06 18:05:46 BUG #3116: attribute has wrong type