Query Casting Help

From: Hunter Hillegas <lists(at)lastonepicked(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Query Casting Help
Date: 2002-07-08 23:21:51
Message-ID: B94F6C9F.56884%lists@lastonepicked.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am trying to execute this little bit:

(extract(month from current_date) + interval '1 month')

The system says I need to cast because it can't figure out how to add
these... I read through the manual and I am still a little confused.

Which side should I be casting? To what datatype?

TIA,

Hunter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2002-07-08 23:25:50 Re: Error messages changes for 7.3?
Previous Message Nigel J. Andrews 2002-07-08 22:53:40 Re: Odd new symptom - database locking up on a query