Re: [GENERAL] macro/inline table valued functions

2010-09-21 Thread Tom Lane
Bret Green 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 a

[GENERAL] macro/inline table valued functions

2010-09-21 Thread Bret Green
Is there anything like a macro or an inline table valued function in postgres? i.e I define a query as a function/macro and reuse the function in queries and the dbms will expand the function/macro to its definition, thus avoiding any overhead. If not what is the closest thing? Thanks