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: (view raw, whole thread or download thread mbox)
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

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.


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-2017 The PostgreSQL Global Development Group