| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Sam Mason <sam(at)samason(dot)me(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: date range query help |
| Date: | 2008-11-20 16:20:16 |
| Message-ID: | 2785.1227198016@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice pgsql-sql |
Sam Mason <sam(at)samason(dot)me(dot)uk> writes:
> I sometimes find it easier to store ranges like this with having the
> open ends at infinity. This is easier with timestamps as they have
> magic 'infinity' values in PG (both positive and negative). Values of
> date type don't have any special values like this which makes things a
> bit more awkward.
Just FYI, date does have +/-infinity as of 8.4.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry Koterov | 2008-11-20 16:52:44 | Propose: enum with all registered table names? |
| Previous Message | Tom Lane | 2008-11-20 16:18:29 | Re: hidden errors calling a volatile function inside a stable function |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rainer Schuetz | 2008-11-21 16:53:52 | Create a function that creates a function which returns a table and return that table in one step |
| Previous Message | Frank Bax | 2008-11-20 13:22:25 | Re: [SQL] date range query help |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | paulo matadr | 2008-11-20 19:04:08 | Res: UPDATE and DELEte with a lot of register is to slow... |
| Previous Message | Frank Bax | 2008-11-20 13:22:25 | Re: [SQL] date range query help |