Skip site navigation (1) Skip section navigation (2)

Re: allow select from void function in void sql function

From: David Fetter <david(at)fetter(dot)org>
To: Jaime Casanova <systemguards(at)gmail(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)hotmail(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: allow select from void function in void sql function
Date: 2006-03-17 05:31:39
Message-ID: 20060317053139.GA3711@fetter.org (view raw or flat)
Thread:
Lists: pgsql-patches
On Thu, Mar 16, 2006 at 10:56:43PM -0500, Jaime Casanova wrote:
> On 3/16/06, Pavel Stehule <pavel(dot)stehule(at)hotmail(dot)com> wrote:
> > Hello
> >
> > this small patch allow use sql for creating wrappers others void
> > functions.  Currently void SQL function have to be empty.
> >
> > create or replace function foo(int) returns void as ' ',''
> > language c ..; create or replace function foo() returns void as $$
> > select foo(10); $$language sql;
> >
> 
> i'm not clear on what the use case of this can be... of course, my
> opinion is not very important :)

I can think of a case.  Let's imagine you want to do (roughly) the
equivalent of CALL, which we don't have yet.  This would let you have
what amounts to a stored procedure, i.e. something that takes an
action but doesn't return rows. :)

Cheers,
D
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!

In response to

pgsql-patches by date

Next:From: Pavel StehuleDate: 2006-03-17 05:37:44
Subject: Re: allow select from void function in void sql function
Previous:From: Qingqing ZhouDate: 2006-03-17 05:29:05
Subject: Re: Automatically setting work_mem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group