Postgres Pro
Downloads
Home   >   mailing lists

Re: append fields for *where...* - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: append fields for *where...*
Date
Msg-id 20050210231250.GA4740@wolff.to
Whole thread Raw
In response to append fields for *where...*  (Johnny C <juandelacruz@gmail.com>)
List pgsql-sql
Tree view 
On Thu, Feb 10, 2005 at 17:45:11 -0500, Johnny C <juandelacruz@gmail.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.

pgsql-sql by date:

Previous
From: Johnny C
Date:
Subject: append fields for *where...*
Next
From: Guillaume LELARGE
Date:
Subject: Re: append fields for *where...*