Thanks Tom, OFFSET is even better solution for me . Regards. Milen -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Wednesday, June 14, 2006 3:57 PM To: Milen Kulev Cc: 'Jim C. Nasby'; pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] Partitioning... "Milen Kulev" <makulev@xxxxxxx> writes: > Thanks Jim, the "trick" worked for me ! >> You might need to add an ORDER BY to the subquery to ensure >> PostgreSQL doesn't pull it into the main query. Actually, the usual trick is "OFFSET 0", which works just as well as an optimization fence and doesn't force any significant extra work. Of course, if you *need* an ORDER BY then that's what to use, but it's overkill if you just want to prevent flattening the subquery. regards, tom lane
