From: "Jaime Casanova" <[EMAIL PROTECTED]>
To: "Pavel Stehule" <[EMAIL PROTECTED]>
CC: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Function's final statement must not be a SELECT
Date: Sat, 11 Mar 2006 12:42:15 -0500
On 3/10/06, Pavel Stehule <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I want do sql wrap for woid plpgsql function. But void SQL function must
not
> finish SELECT cmd. I don't know any others command which I can use.
>
> Can You help me?
> Thank You
> Pavel Stehule
>
perform * from your_table;
Sorry, I need SQL construct. Please try:
create or replace function foo(bool) returns void as $$ ... $$ language
plpgsql volatile strict;
I can't to do:
create or replace function wrapper() returns void as $$ select foo(true); $$
language sql volatile strict;
Regards
Pavel
_________________________________________________________________
Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq