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

Re: Calling void functions

From: "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com>
To: peter_e(at)gmx(dot)net
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Calling void functions
Date: 2007-04-02 12:18:21
Message-ID: BAY114-F172B63B4F29F9DEF0C1A57F9600@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-hackers
>I'm informed that the last statement of a function that returns void cannot 
>be a SELECT.  How else is one supposed to call another function which also 
>returns void?
>
>E.g.,
>
>CREATE FUNCTION foo (a int, b int) RETURNS void
>	LANGUAGE plpgsql
>	AS $$ do important things $$;
>
>CREATE FUNCTION foo (a int) RETURNS void
>	LANGUAGE sql
>	AS $$ SELECT foo($1, default-value); $$;

Hello Peter

it's problem. You cannot do it now. One year ago I sent patch

http://archives.postgresql.org/pgsql-patches/2006-03/msg00196.php

Regards
Pavel Stehule

_________________________________________________________________
Chcete sdilet sve obrazky a hudbu s prateli? http://messenger.msn.cz/


Responses

pgsql-hackers by date

Next:From: Pavan DeolaseeDate: 2007-04-02 12:21:13
Subject: HOT WIP Patch - version 6.3
Previous:From: Magnus HaganderDate: 2007-04-02 08:46:08
Subject: Re: Last minute mini-proposal (I know, I know)forPQexecf()

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