Re: "oracle to postgresql" conversion

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: "oracle to postgresql" conversion
Дата
Msg-id 1173466651.20651.294.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: "oracle to postgresql" conversion  (Devrim GÜNDÜZ <devrim@CommandPrompt.com>)
Ответы Re: "oracle to postgresql" conversion  ("Chris Fischer" <Chris.Fischer@channeladvisor.com>)
Список pgsql-general
On Thu, 2007-03-08 at 16:05, Devrim GÜNDÜZ wrote:
> Hi,
>
> On Fri, 2007-03-09 at 05:21 +1030, Shane Ambler wrote:
> > NUMBER is Oracle's version of NUMERIC - Oracle will use both but
> > probably only Oracle will use NUMBER.
>
> Really? I thought Oracle's NUMBER ~ PostgreSQL's (BIG)INT?

Not sure.  It let me assign a precision to it, so I figured it wasn't
int based.  In fact, it accepts precision up to 38, just like numeric,
and it accepts non-decimal portions, i.e.:

number(20,4);

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

Предыдущее
От: Kenneth Downs
Дата:
Сообщение: Re: HIPPA (was Re: Anyone know ...)
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Setting week starting day