Re: Why select * from function doesn't work when function

Tom Lane wrote:

> "Francisco Figueiredo Jr."  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
> ------------------
>  record
>  cstring
>  any
>  anyarray
>  void
>  trigger
>  language_handler
>  internal
>  opaque
>  anyelement
> (10 rows)
> 
> regression=#
> 
> Some of these might be safe to allow, but some clearly are not.
> 
> 			regards, tom lane
> 

Ohhh, I thought there was only the void type which had this behaviour. :)

So, I will have to use the select voidfunction();

Thanks Tom Lane.




-- 
Regards,

Francisco Figueiredo Jr.

------
"My grandfather once told me that there are two
kinds of people: those
who work and those who take the credit. He told me
to try to be in the
first group; there was less competition there."
- Indira Gandhi