Return type bug in functions - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Return type bug in functions
Date
Msg-id 20030511185709.B86597-100000@houston.familyhealth.com.au
Whole thread Raw
Responses Re: Return type bug in functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Plans for index names unique to a table?
Next
From: Tom Lane
Date:
Subject: Re: Return type bug in functions