Calling void functions - Mailing list pgsql-sql

From Peter Eisentraut
Subject Calling void functions
Date
Msg-id 200704021002.26282.peter_e@gmx.net
Whole thread Raw
Responses Re: Calling void functions  ("Daniel Caune" <daniel.caune@ubisoft.com>)
Re: Calling void functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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 voidLANGUAGE plpgsqlAS $$ do important things $$;

CREATE FUNCTION foo (a int) RETURNS voidLANGUAGE sqlAS $$ SELECT foo($1, default-value); $$;

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sequence vs Serial
Next
From: "Daniel Caune"
Date:
Subject: Re: Calling void functions