Re: Optimize querry sql

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Optimize querry sql
Date: 2007-09-14 15:17:13
Message-ID: dcc563d10709140817l50fae6aah40ff3a1b681e5bb4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 9/14/07, A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com> wrote:
> am Fri, dem 14.09.2007, um 8:36:47 -0500 mailte Scott Marlowe folgendes:
> > On 9/14/07, A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com> wrote:
> >
> > > And use CURRENT_DATE instead now().
> >
> > Out of curiosity, why the advice to switch from now() to CURRENT_DATE?
>
> Mhh, don't know...

OK, I was just afraid there was some "bad thing" TM that I wasn't
aware of with now(), which, btw, I use all the time. whew.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Glaesemann 2007-09-15 14:25:46 Re: Optimize querry sql
Previous Message A. Kretschmer 2007-09-14 14:52:03 Re: Optimize querry sql