On 21 August 2014 11:36, Patrick Dung <patrick_...@yahoo.com.hk> wrote:
> 2. > now() is dynamic but it scan all the partitioned tables. > Most likely you partitioned on a timestamp without time zone, while now() returns a timestamp with time zone. The possible time zone difference causes that the database doesn't know in which partition to look. In a similar vein, the function you defined to return your timestamp you marked 'immutable', which it should most definitely not be; time moves on, after all. -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest.
