opaque in sql function

Started by Michaël Fieyalmost 26 years ago2 messagesgeneral
Jump to latest
#1Michaël Fiey
m.fiey@futuresoundtech.com

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.

#2Alex Bolenok
abolen@pisem.net
In reply to: Michaël Fiey (#1)
Re: opaque in sql function

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.