From: | "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com> |
---|---|
To: | systemguards(at)gmail(dot)com |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Function's final statement must not be a SELECT |
Date: | 2006-03-11 18:27:07 |
Message-ID: | BAY20-F23FBBF79F7917054550DC6F9E20@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
>To: "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com>
>CC: pgsql-hackers(at)postgresql(dot)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 <pavel(dot)stehule(at)hotmail(dot)com> 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2006-03-11 20:21:43 | Re: random observations while testing with a 1,8B row |
Previous Message | Stefan Kaltenbrunner | 2006-03-11 18:23:31 | Re: problem with large maintenance_work_mem settings and |