Re: append fields for *where...*

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Johnny C <juandelacruz(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: append fields for *where...*
Date: 2005-02-10 23:12:50
Message-ID: 20050210231250.GA4740@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Feb 10, 2005 at 17:45:11 -0500,
Johnny C <juandelacruz(at)gmail(dot)com> wrote:
>
> How can you make month (append) - 01 - (append) year? and
> pass that as a condition to the field date? Is this possible?

You can EXTRACT the day of the month from the date. If you need this
to use an index, you can create a functional index.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Guillaume LELARGE 2005-02-11 08:24:07 Re: append fields for *where...*
Previous Message Johnny C 2005-02-10 22:45:11 append fields for *where...*