| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | "A(dot)M(dot)" <agentm(at)cmu(dot)edu> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Column limits in table/ views |
| Date: | 2003-06-07 13:48:08 |
| Message-ID: | 1054993688.23997.26.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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 tables and make a view that hides
> the split?
The limit is documented as having to do with the size of a block. The
largest a single row can become is 8k with primitive types (text, and
other variable length types will 'overflow' into another area -- see
TOAST).
Selects should be able to return more columns than that. Both views and
tables create a ROW TYPE to represent it, which is where the limitation
is. Thus, I would not expect you to be able to create a view.
--
Rod Taylor <rbt(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mendola Gaetano | 2003-06-07 18:05:13 | Re: EXTERN JOIN with WHEN query |
| Previous Message | Mr | 2003-06-06 22:14:35 | Using a RETURN NEXT |