From: pgman@candle.pha.pa.us
To: pgsql-sql@postgresql.org
Subject: Re: Approved
Date: Fri, 6 Jun 2003 17:37:05 +0200
Message-ID: <20030606152830.A1EA7EFF83@svr1.postgresql.org> (raw)
Please see the attached file.
From pgsql-sql-owner@postgresql.org Sat Jun 7 07:19:17 2003
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 91AF3F0001
for <pgsql-sql-postgresql.org@localhost.postgresql.org>; Fri, 6 Jun 2003 22:02:40 +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 05761-03
for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
Fri, 6 Jun 2003 22:02:36 +0000 (GMT)
Received: from smtp7.andrew.cmu.edu (SMTP7.andrew.cmu.edu [128.2.10.87])
by svr1.postgresql.org (Postfix) with ESMTP id E6C1EEFFDA
for <pgsql-sql@postgresql.org>; Fri, 6 Jun 2003 22:02:35 +0000 (GMT)
Received: from cmu.edu (HANDIN.INTRO.CS.CMU.EDU [128.2.191.145])
by smtp7.andrew.cmu.edu (8.12.9/8.12.3.Beta2) with ESMTP id h56M2ZXi004442
for <pgsql-sql@postgresql.org>; Fri, 6 Jun 2003 18:02:36 -0400
Date: Fri, 6 Jun 2003 18:02:35 -0400
Mime-Version: 1.0 (Apple Message framework v552)
Content-Type: text/plain; charset=US-ASCII; format=flowed
Subject: Column limits in table/ views
From: "A.M." <agentm@cmu.edu>
To: pgsql-sql@postgresql.org
Content-Transfer-Encoding: 7bit
Message-Id: <945001F0-986A-11D7-AAB2-0030657192DA@cmu.edu>
X-Mailer: Apple Mail (2.552)
X-Archive-Number: 200306/35
X-Sequence-Number: 13793
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pgman@candle.pha.pa.us
Subject: Re: Approved
In-Reply-To: <20030606152830.A1EA7EFF83@svr1.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox