Re: Unknown kind of return type specified for function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Avi Schwartz <avi(at)CFFtechnologies(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unknown kind of return type specified for function
Date: 2003-06-15 18:01:44
Message-ID: 25160.1055700104@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Avi Schwartz <avi(at)CFFtechnologies(dot)com> writes:
> Tom, your example showed me what my problem was.
> I was doing a 'select * from function(1,2,3)' instead for just 'select
> function(1,2,3)'

> Some of the error messages returned are so cryptic it is scary...

I agree, this one's pretty unhelpful, although in the original author's
defense I don't think he realized that users would actually get to see
this case.

As of a few seconds ago, CVS tip will say

ERROR: function foo() in FROM has unsupported return type

which hopefully is a little more useful.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Seichter 2003-06-15 18:16:20 Using postgreSQL on SAN/NAS
Previous Message Tom Lane 2003-06-15 17:25:19 Re: full featured alter table?