Data type confusion

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Data type confusion
Дата
Msg-id web-97089@davinci.ethosmedia.com
обсуждение исходный текст
Ответы Re: Data type confusion
Список pgsql-sql
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

Вложения

В списке pgsql-sql по дате отправления:

Предыдущее
От: Allan Engelhardt
Дата:
Сообщение: Inheritance is completely broken [was: Re: Creating foreign key constraint to child table?]
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: Re: Date Time Functions - ANSI SQL ?