Postgres Pro
Downloads
Home   >   mailing lists

Data type confusion - Mailing list pgsql-sql

From Josh Berkus
Subject Data type confusion
Date
Msg-id web-97089@davinci.ethosmedia.com
Whole thread Raw
Responses Re: Data type confusion
List pgsql-sql
Tree view 
Tom, Stephan,

I'm writing up the date/time FAQ, and I came across some operator
behavior that confuses me:

If
INTERVAL / INTEGER = INTERVAL

then why does
INTERVAL / INTERVAL = ERROR?

Shouldn't
INTERVAL / INTERVAL = INTEGER?

I'd like to answer this before I finish the FAQ, as it seems
inconsistent behavior.

-Josh


______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
Attachment

pgsql-sql by date:

Previous
From: Allan Engelhardt
Date:
Subject: Inheritance is completely broken [was: Re: Creating foreign key constraint to child table?]
Next
From: "Josh Berkus"
Date:
Subject: Re: Re: Date Time Functions - ANSI SQL ?