Thanks Tom, OFFSET is even better solution for me . Regards. Milen
-----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 14, 2006 3:57 PM To: Milen Kulev Cc: 'Jim C. Nasby'; pgsql-general@postgresql.org Subject: Re: [GENERAL] Partitioning... "Milen Kulev" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
