Is there a chance you don't know PL/pgSQL that well, either?

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #18,243 by drewk 11/14/01 11:04:10 AM Reply	Is there a chance you don't know PL/pgSQL that well, either? Not being funny here. Is "RETURN OPAQUE" their way of returning a result set? The docs don't seem very clear, and I don't have a working installation handy right now to test it. We have to fight the terrorists as if there were no rules and preserve our open society as if there were no terrorists. -- [link\|http://www.nytimes.com/2001/04/05/opinion/BIO-FRIEDMAN.html\|Thomas Friedman]
Post #18,263 by admin 11/14/01 12:44:50 PM Reply	No. Unless they've changed it since 7.0.3. I explored the issue pretty thoroughly back then. 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. Regards, -scott anderson
Post #18,271 by drewk 11/14/01 1:28:05 PM Reply	Christian's right: what are they thinking We have to fight the terrorists as if there were no rules and preserve our open society as if there were no terrorists. -- [link\|http://www.nytimes.com/2001/04/05/opinion/BIO-FRIEDMAN.html\|Thomas Friedman]

Anybody familiar with PL/PGSQL and/or PL/SQL? - (drewk) - (8) - Nov. 13, 2001, 01:49:08 PM EST

You very funny man... - (admin) - (6) - Nov. 13, 2001, 01:53:09 PM EST

I was afraid of that - (drewk) - (5) - Nov. 13, 2001, 02:00:24 PM EST

Alternative... - (ChrisR) - Nov. 13, 2001, 02:04:07 PM EST

The good news... - (admin) - (3) - Nov. 13, 2001, 02:08:13 PM EST

Is there a chance you don't know PL/pgSQL that well, either? - (drewk) - (2) - Nov. 14, 2001, 11:04:10 AM EST

No. - (admin) - (1) - Nov. 14, 2001, 12:44:50 PM EST

Christian's right: what are they thinking -NT - (drewk) - Nov. 14, 2001, 01:28:05 PM EST

Sorry, I only know one of those... - (CRConrad) - Nov. 14, 2001, 06:54:26 AM EST

Dvorak-keyboard powered!
75 ms