Re: macro/inline table valued functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bret Green <bret(dot)green(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: macro/inline table valued functions
Date: 2010-09-22 01:34:07
Message-ID: 13503.1285119247@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bret Green <bret(dot)green(at)yahoo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bryan Murphy 2010-09-22 02:06:42 Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working
Previous Message Merlin Moncure 2010-09-22 01:10:38 Re: versioned pl/pgsql functions