Re: [SQL] create view with numeric data

2003-03-31 Thread Tomasz Myrta
Uz.ytkownik cio198 napisa?: Hello, i've created this table CREATE TABLE "budget" ( "year" character varying NOT NULL, "month" character varying NOT NULL, "accountno" character varying NOT NULL, "costid" character varying NOT NULL, "valutacode" character va

Re: [SQL] create view with numeric data

2003-03-31 Thread Tom Lane
[EMAIL PROTECTED] (cio198) writes: > The problem is the numeric data in the view isn't limited to > numeric(9,2) instead it become numeric(65535, 65531). It should look like plain, unrestricted "numeric". Whatever is showing you those bogus precision/scale fields is wrong. What client software a

[SQL] create view with numeric data

2003-03-31 Thread cio198
Hello, i've created this table CREATE TABLE "budget" ( "year" character varying NOT NULL, "month" character varying NOT NULL, "accountno" character varying NOT NULL, "costid" character varying NOT NULL, "valutacode" character varying, "budgetvalue"