This may need to be made more obvious in the documentation...
Having both SQL and PL/PgSQL languages is one of those things that is different enough from other database systems that
manypeople will not expect and may not notice it unless it is pointed out explicitly and prominently.
On Jul 10, 2010, at 1:07 AM, Craig Ringer wrote:
> For such simple expressions, you should use 'SQL' functions. These can
> often be inlined to allow the query planner to avoid call overheads
> entirely, and are WAY cheaper even if they can't be inlined. They're
> less flexible, but much faster.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice