Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> writes: > Erik Jones wrote: >> current_user() is a stable function and the manual is explicit that the result of stable function can be used in an index scan: > Yes ... but the planner doesn't know the value current_user will return, I think it's got nothing to do with that and everything to do with the fact that he's comparing to a varchar rather than text column ... 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
