Tag Info

New answers tagged

5

Very short answer : No new datatypes have been created to accommodate you. While we are on this subject Let's try plain SQL USE test DROP TABLE IF EXISTS numtest; CREATE TABLE numtest ( id int not null auto_increment, xx decimal(10,3) default null, primary key (id) ); INSERT INTO numtest (id) values (0),(0),(0),(0),(0); SELECT * FROM numtest; ...


4

In the absence of any answers I've explored the issue further myself. It looks like user-defined functions can handle all base types, including bytea and smallint[], so this doesn't affect the choice of representation much. I tried out several different representations on a PostgreSQL 9.4 server running locally on a Windows 7 laptop with a vanilla ...



Top 50 recent answers are included