On 5/27/02 8:49 AM, "Jani Averbach" <jaa(at)cc(dot)jyu(dot)fi> wrote:
> On Mon, 27 May 2002, dirk heitmann wrote:
>
>> i have created a table with 1600 comlumns. Now i want
>> to update some columns with new values:
>> update db set col1=1 where col2=2;
>>
>> this generates the error-message:
>> heap_formtuple: numberOfAttributes of 1601 > 1600.
>>
>
> --8<--
> Maximum number of columns in a table 1600
> --8<--
>
> http://www2.se.postgresql.org/users-lounge/limitations.html
>
Does this limit only apply to a "defined table" (such as a table or view) ro
does it also apply to the result of any select, for example a two-table join
which would have 1601 output columns?
-- sgl