Postgres Pro
Downloads
Home   >   mailing lists

Re: macro/inline table valued functions - Mailing list pgsql-general

From Tom Lane
Subject Re: macro/inline table valued functions
Date
Msg-id 13503.1285119247@sss.pgh.pa.us
Whole thread Raw
In response to macro/inline table valued functions  (Bret Green <bret.green@yahoo.com>)
List pgsql-general
Tree view 
Bret Green <bret.green@yahoo.com> writes:
> Is there anything like a macro or an inline table valued function in postgres?

Recent versions can inline SQL-language functions, if they consist of
a simple SELECT and meet a few other constraints.  I think the main
nonobvious constraint is they should be marked STABLE and not STRICT.

            regards, tom lane

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: versioned pl/pgsql functions
Next
From: Bryan Murphy
Date:
Subject: Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working