Are SQL functions better than PG/SQL ones? - Mailing list pgsql-general

From Vitaly Belman
Subject Are SQL functions better than PG/SQL ones?
Date
Msg-id ccoi28$imu@odah37.prod.google.com
Whole thread Raw
Responses Re: Are SQL functions better than PG/SQL ones?  (mike g <mike@thegodshalls.com>)
List pgsql-general
I ready somewhere that PostgreSQL is able to optimize SQL functions,
the same way it does with views. For example if you do:

select * from cv_customers() order by customer_id;

When customers is an SQL function the optimizer/planner will be able to
actually use the customer_id index.

From some tests I made it doesn't seem true.. Yet I am asking to know
for sure.


pgsql-general by date:

Previous
From: homecurr@yahoo.com
Date:
Subject: change the last bit
Next
From: "David Parker"
Date:
Subject: Re: moving an installation