Re: Can't figure out how to use now() in default for tsrange column (PG 9.2) - Mailing list pgsql-general

From Tom Lane
Subject Re: Can't figure out how to use now() in default for tsrange column (PG 9.2)
Date
Msg-id 12232.1342492331@sss.pgh.pa.us
Whole thread Raw
In response to Re: Can't figure out how to use now() in default for tsrange column (PG 9.2)  (Daniele Varrazzo <daniele.varrazzo@gmail.com>)
List pgsql-general
Daniele Varrazzo <daniele.varrazzo@gmail.com> writes:
> This suggests me that the PG histogram doesn't count the occurrence
> into bins of the same size over the domain, but instead records the
> boundaries on the domain of bins containing the same amount of data.

Right.  I don't believe the PG planner has any issues with infinite
dates (and if you do find one, we'll do our best to fix it).  But the
point that client-side code might not cope with infinite dates is
very valid, and that's not something that we can undertake to fix
if you run into it.

            regards, tom lane

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Create stored procedure from C#.net
Next
From: Rafal Pietrak
Date:
Subject: Re: Can't figure out how to use now() in default for tsrange column (PG 9.2)