X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id C3EB4F0044 for ; Sat, 7 Jun 2003 18:09:12 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 49704-07 for ; Sat, 7 Jun 2003 18:09:02 +0000 (GMT) Received: from smtp.noos.fr (nan-smtp-03.noos.net [212.198.2.72]) by svr1.postgresql.org (Postfix) with ESMTP id 8FBEFF001F for ; Sat, 7 Jun 2003 18:09:01 +0000 (GMT) Received: (qmail 3723183 invoked by uid 0); 7 Jun 2003 18:09:01 -0000 Received: from unknown (HELO gmendola) ([212.198.40.246]) (envelope-sender ) by 212.198.2.72 (qmail-ldap-1.03) with SMTP for ; 7 Jun 2003 18:09:01 -0000 Message-ID: <004e01c32d1f$dd2b3ba0$10d4a8c0@mm.eutelsat.org> From: "Gaetano Mendola" To: "A.M." , References: <945001F0-986A-11D7-AAB2-0030657192DA@cmu.edu> Subject: Re: Column limits in table/ views Date: Sat, 7 Jun 2003 20:08:56 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Archive-Number: 200306/65 X-Sequence-Number: 13823 "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 tables and make a view that hides > the split? Hi, just for curiosity, can I known why do you need a table or a view with more then 560 Columns ? Usually have a big table like yours is sign of a not good design. Regards Gaetano Mendola