By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,728 Members | 1,107 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,728 IT Pros & Developers. It's quick & easy.

inlined sql functions in 7.4

P: n/a
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?

Thx in advance

Aleksey
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #1
Share this Question
Share on Google+
3 Replies

P: n/a
--- Aleksey Serba <as****@voltweb.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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2

P: n/a
Aleksey Serba <as****@voltweb.com> writes:
I found the very useful feature into 7.4 release
Function-inlining for simple SQL functions

but, i can't find any docs about syntax :(


There isn't any --- it happens automatically if the planner thinks it's
an appropriate transformation.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #3

P: n/a
I found the very useful feature into 7.4 release
Function-inlining for simple SQL functions

but, i can't find any docs about syntax :(


TL> There isn't any --- it happens automatically if the planner thinks it's
TL> an appropriate transformation.
TL> regards, tom lane

Ops. I was mistaken.
I'm sorry for wasting your time.

Aleksey
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.