Craig Ringer <craig@xxxxxxxxxxxxxxxxxxxxx> writes: > Is there any way to get postgresql to detect such repeated query parts > and evaluate them only once? No, not at the moment. In principle the planner could look for such duplicates, but it'd be wasted cycles so much of the time that I'd be loath to do it. There is work afoot to implement the SQL:2003 "WITH" syntax, which I think would offer a syntactic solution to your problem. 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
