Max Columns in a SQL Select

From: PS PS <psus2020(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Max Columns in a SQL Select
Date: 2004-05-17 16:37:36
Message-ID: 20040517163736.23605.qmail@web20311.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

SQL Guru's,

Does anyone know what is the Column Limit in a SQL
Query in Oracle RDB version 7.1?

I've about 200 columns in my SQL query. Each column
is a computed column -- Case when a = b Then c Else 0
End.

It gives me a runtime error -- abnormal program
termination -- upon execution.

Thanks a lot in advance.



__________________________________
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Karsten Hilbert 2004-05-17 16:51:13 Re: Unique Constraint with foreign Key
Previous Message Stephan Szabo 2004-05-17 15:01:07 Re: a wierd query