Sam Mason <sam@xxxxxxxxxxxxx> writes: > If it's an SQL function and marked as IMMUTABLE it should (I believe > anyway) get inlined somewhere along the line and take no more overhead > than writing it out in full. Actually, if you're intending that a SQL function be inline-able then it's best *not* to mark it as IMMUTABLE (nor STRICT either). If the marking matches the behavior of the contained expression then it doesn't matter, but if the marking is stricter than the expression it will prevent inlining. Rather than think hard, I usually just don't annotate the SQL function at all. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
