Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] merging some features from plpgsql2 project - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [HACKERS] merging some features from plpgsql2 project
Date
Msg-id CAFj8pRBYsAFMANcLi+LmEz_cw23vwkQZcZVG0pXd+FVFrkG45A@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] merging some features from plpgsql2 project  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: [HACKERS] merging some features from plpgsql2 project  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
Tree view


so some possible design can be:

DECLARE
  PRAGMA UNCACHED_PLANS;
BEGIN
  SELECT ... INTO ;
  SELECT ... INTO ;
END;

This respects Ada and PL/SQL style - probably easy implementation 

Regards

Pavel

some examples based on Ada doc

FUNCTION xxx RETURN int AS 
  PRAGMA yyy -- pragma has function scope
BEGIN

FUNCTION xxx RETURN int AS
BEGIN
  DECLARE
    PRAGMA yyy -- pragma has block scope

Regards

Pavel

 
 

Regards



 

merlin



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Replication/backup defaults
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] generating fmgr prototypes automatically