CALL optional in PL/pgSQL - Mailing list pgsql-hackers

From Peter Eisentraut
Subject CALL optional in PL/pgSQL
Date
Msg-id 093a9770-42a8-8f8c-a0b6-060fe742a010@2ndquadrant.com
Whole thread Raw
Responses Re: CALL optional in PL/pgSQL  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: CALL optional in PL/pgSQL  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
This seems to be a popular issue when porting from PL/SQL, so I'll throw
it out here for discussion.  Apparently, in PL/SQL you can call another
procedure without the CALL keyword.  Here is a patch that attempts to
implement that in PL/pgSQL as well.  It's not very pretty.

I seem to recall that there were past discussions about this, with
respect to the PERFORM command, but I couldn't find them anymore.

Also, I think PL/SQL allows you to call a procedure with no arguments
without parentheses.  I have not implemented that.  I think it could be
done, but it's not very appealing.

If anyone has more details about the PL/SQL side of this, that would be
useful.  What I could find is that using CALL and not using CALL appear
to be equivalent.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: [HACKERS] SERIALIZABLE with parallel query
Next
From: Amit Langote
Date:
Subject: Re: [HACKERS] path toward faster partition pruning