Look like the mysql people found a subquery that postgresql doesn't
handle as good as possible:
http://s.petrunia.net/blog/
Is there some deeper issue here that I fail to see or is it simply that
it hasn't been implemented but is fairly straigt forward? In the link
above they do state that it isn't a very common case anyway.
/Dennis