Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group