getScale() and getPrecision()

Поиск
Список
Период
Сортировка
От David Esposito
Тема getScale() and getPrecision()
Дата
Msg-id PEEDKNLDICKECFBNGNLLGEHPCBAA.esposito@newnetco.com
обсуждение исходный текст
Ответы getScale() and getPrecision() patch
Список pgsql-jdbc
Is there a reason that getScale() and getPrecision() both return zero for
NUMERIC fields? It seems like this shouldn't be the case. In the example
fields below (generated by doing a \d on the table), it would seem like the
getScale and Precision methods should return the numbers contained in the
parentheses.

Or at least that's how the docs seem to read and that's how Oracle does it
too ... ;)

 catalog_item_id                | numeric(11,0)            | not null
 catalog_item_category_id       | numeric(11,0)            | not null
 catalog_item_manufacturer_no   | character varying(20)    |
 catalog_item_manufacturer_url  | character varying(50)    |
 catalog_item_retail_price      | numeric(11,2)            | not null
 catalog_item_member_price      | numeric(11,2)            | not null
 catalog_item_sellable          | numeric(1,0)             | not null

-Dave


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

Предыдущее
От: Ned Wolpert
Дата:
Сообщение: Returning oid or primary key
Следующее
От: "David Esposito"
Дата:
Сообщение: getScale() and getPrecision() patch