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 many people 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@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
