Looking for two datatypes...

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Looking for two datatypes...
Дата
Msg-id 3965F31D.3D5C3664@cupid.suninternet.com
обсуждение исходный текст
Список pgsql-general
For a system we're building here, it would be really nice
if we could find certain types that behave in certain
ways.

1. A currency type. Like money only not restricted to
dollars. Could store any currency available and format
it appropriately for output. Would fail if you tried
to add yen to dollars. Distinguish between australian
and american dollars. Actually, output not so important.

I guess you could emulate this with two separate fields
but enforcing rules would be not so easy.

2. A datetime type that would store the timezone as
well. All operations would be in the timezone the
datetime "is". Would have conversion functions
to switch to different timezones.

This could also be done with two fields. But it's
the automatic conversions that make it useful...

Do implementations of these types exist? If so, where?
If not, what would be the estimated complexity? They
don't *seem* too difficult...
--
Martijn van Oosterhout <kleptog@cupid.suninternet.com>
http://cupid.suninternet.com/~kleptog/

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

Предыдущее
От: "Andrew Snow"
Дата:
Сообщение: RE: proposed improvements to PostgreSQL license
Следующее
От: Dave Smith
Дата:
Сообщение: Re: libpq connectivity