2011/1/17 Tom Lane <[email protected]>: > Pavel Stehule <[email protected]> writes: >> it should to work without functional index - but not sure about effectivity > > As long as the function is VOLATILE, the planner can't use any > intelligent query plan. Merge or hash join both require at least > stable join keys.
sure, my first advice was a question about function volatility - and my sentence was related to using immutable function. regards Pavel Stehule > > regards, tom lane > -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
