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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Francisco Figueiredo Jr(dot)" <fxjrlists(at)yahoo(dot)com(dot)br>
Cc: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Why select * from function doesn't work when function
Date: 2003-07-24 14:45:45
Message-ID: 23149.1059057945@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Francisco Figueiredo Jr." <fxjrlists(at)yahoo(dot)com(dot)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
------------------
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-07-24 14:48:06 Re: libpq_r
Previous Message Lee Kindness 2003-07-24 14:45:13 Re: libpq_r