Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> 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