Re: [SQL] Column limits in table/ views

2003-06-09 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > On Fri, 2003-06-06 at 18:02, A.M. wrote: >> I have 560 columns of NUMERIC(10,14). To not run up against max column=20 >> restraints, I split the information into two tables. Does the column=20 >> limit on tables imply the same limit for views or selects or c

Re: [SQL] Column limits in table/ views

2003-06-09 Thread Gaetano Mendola
"A.M." <[EMAIL PROTECTED]> wrote: > I have 560 columns of NUMERIC(10,14). To not run up against max column > restraints, I split the information into two tables. Does the column > limit on tables imply the same limit for views or selects or could I > potentially select a row across both table

Re: [SQL] Column limits in table/ views

2003-06-09 Thread Rod Taylor
On Fri, 2003-06-06 at 18:02, A.M. wrote: > I have 560 columns of NUMERIC(10,14). To not run up against max column > restraints, I split the information into two tables. Does the column > limit on tables imply the same limit for views or selects or could I > potentially select a row across both t

[SQL] Column limits in table/ views

2003-06-07 Thread A.M.
I have 560 columns of NUMERIC(10,14). To not run up against max column restraints, I split the information into two tables. Does the column limit on tables imply the same limit for views or selects or could I potentially select a row across both tables and make a view that hides the split? -