Re: Why select * from function doesn't work when function - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Why select * from function doesn't work when function
Date
Msg-id 23149.1059057945@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why select * from function doesn't work when function  ("Francisco Figueiredo Jr." <fxjrlists@yahoo.com.br>)
Responses Re: Why select * from function doesn't work when function  ("Francisco Figueiredo Jr." <fxjrlists@yahoo.com.br>)
List pgsql-hackers
"Francisco Figueiredo Jr." <fxjrlists@yahoo.com.br> writes:
> I just wanted void functions behave like others when called as select * 
> from voidfunction  So I dont have to do select voidfunction. :)

It's not only void functions that fail --- I believe the code will
reject any pseudo-type, which includes several things:

regression=# select typname from pg_type where typtype = 'p';    typname
------------------recordcstringanyanyarrayvoidtriggerlanguage_handlerinternalopaqueanyelement
(10 rows)

regression=#

Some of these might be safe to allow, but some clearly are not.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re:
Next
From: Lee Kindness
Date:
Subject: Re: libpq_r