Return type bug in functions

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Return type bug in functions
Date: 2003-05-11 10:59:31
Message-ID: 20030511185709.B86597-100000@houston.familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Guys,

What's with this:

test=# create function foo() returns integer as 'select 1;' language
'sql';
CREATE FUNCTION
test=# create function foo2() returns "integer" as 'select 1;' language
'sql';
ERROR: Type "integer" does not exist

Why can't you quote return types? Isn't that inconsistent with the rest
of Postgres? Also, what about user-defined types that have spaces,
japanese characters, etc.?

Noticed this while working on phpPgAdmin...

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-05-11 14:12:54 Re: Return type bug in functions
Previous Message Tom Lane 2003-05-11 02:46:25 Re: realtime data inserts