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

Reply via email to