2011/1/17 Tom Lane <tgl@xxxxxxxxxxxxx>: > Pavel Stehule <pavel.stehule@xxxxxxxxx> 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
