Home > mailing lists

Re: current_date vs 'now' - Mailing list pgsql-sql

From	Jamie Tufnell
Subject	Re: current_date vs 'now'
Date	February 5, 2009 22:21:43
Msg-id	b0a4f3350902051521x3c569045wa586f8e8fea883c2@mail.gmail.com Whole thread Raw
In response to	Re: current_date vs 'now' (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-sql

Tree view

On 2/6/09, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> As the view definition printout suggests, tomorrow this view will produce
>
>  2009-02-06 | 2009-02-05
>
> because the constant isn't going to change.

Thanks for that explanation Tom.  Very clear and helpful.

Jamie

pgsql-sql by date:

From: Michael B Allen
Date: 05 February 2009, 20:57:44
Subject: Must I use DISTINCT?

From: Raj Mathur
Date: 06 February 2009, 02:34:29
Subject: Re: Array iterator

Re: current_date vs 'now' - Mailing list pgsql-sql

Previous

Next