From: "Josh Berkus" <josh@agliodbs.com>
Subject: Re: Dateadd
To: pgsql-sql@postgresql.org
Date: Sat, 05 May 2001 14:44:28 -0700
Message-ID: <web-52014@davinci.ethosmedia.com>
In-Reply-To: <20010504175816.A14070@cornell.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit

Folks,

	FYI - this difference in syntax is because PostgreSQL implements real
SQL operators (i.e. what the operator does and what arguments it takes
depend on the data types involved) and Microsoft does not (in MS SQL,
operators mean the same thing for almost all data types).

	Speaking of which, why doesn't PostgreSQL allow the use of "+" between
two VARCHARs to mean the same as "||" ?  Is there an addition operation
for PgSQL for VARCHAR other than concatination?

-Josh


> > I need to know if there is a sql function implemented in postgres
> that gives
> > me a date plus any number of days, months or years (the traditional
> dateadd
> > function) or how to do it in sql?


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco