Re: inlined sql functions in 7.4

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: Aleksey Serba <aserba(at)voltweb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: inlined sql functions in 7.4
Date: 2004-02-29 17:34:49
Message-ID: 20040229173449.98982.qmail@web20813.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- Aleksey Serba <aserba(at)voltweb(dot)com> wrote:
> Hi!
>
> I found the very useful feature into 7.4 release
>
> > Release Notes 7.4:
> > Function-inlining for simple SQL functions
> > Simple SQL functions can now be inlined by
> including their SQL in the main query.
> > This improves performance by eliminating
> per-call overhead.
> > That means, simple SQL functions now behave
> like macros.
>
> but, i can't find any docs about syntax :(
>
> Could you point me in the right direction?

This happens automatically, i.e. you don't need to do
anything. It is a performance optimization in the
backend.

>
> Thx in advance
>
> Aleksey
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-02-29 17:42:35 Re: inlined sql functions in 7.4
Previous Message Shri Shrikumar 2004-02-29 16:49:59 Are Triggers Synchronous