Re: opaque in sql function - Mailing list pgsql-general

From Alex Bolenok
Subject Re: opaque in sql function
Date
Msg-id 002101bffaf4$60781570$df02a8c0@artey.ru
Whole thread Raw
In response to opaque in sql function  (Michaël Fiey <m.fiey@futuresoundtech.com>)
List pgsql-general
> In the doc I read it's possible to use 'opaque' as rtype in sql
> functions, but when I try to create a sql function with return opaque I
got
> the message 'ProcedureCreate : sql functions cannot return type
"opaque"...
> When I declare tye function as 'plpgsql' return opaque is ok, but on exec
> I got the message "Invalid TypeIdTypeRelId - oid -0"
> I use Pg 7.0.2 with redhat 6.1.

OPAQUE datatype is used only by internal functions that make calls to other
functions. It is not datatype actually, but some kind of instruction to make
no assumptions about return type. Actual meaning depends on what function is
it - trigger, constraint etc. You cannot use OPAQUE functions in queries.

Alex Bolenok.


pgsql-general by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: Inheritance
Next
From: g
Date:
Subject: Re: select question