Re: MAX(column1),MAX(column2),...

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Bjarte Aagnes <bjartea(at)student(dot)sv(dot)uio(dot)no>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: MAX(column1),MAX(column2),...
Date: 2002-04-15 19:34:14
Message-ID: web-1371121@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

Bjarte,

> How do I list all column names and maximum values for each column in
> a table.
> I can list the column names, but can't see how to get the maximum of
> each
> column without typing max(name) for every column.

That is exactly what you have to do. I do not understand the problem.
If you are looking for some way to save yourself typing the column
names, it doesn't exist.

-Josh Berkus

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Travis Hoyt 2002-04-15 20:17:10 Re: MAX(column1),MAX(column2),...
Previous Message Joshua b. Jore 2002-04-15 19:29:57 Re: SQL-Dump and refertial Integrity

Browse pgsql-sql by date

  From Date Subject
Next Message Travis Hoyt 2002-04-15 20:17:10 Re: MAX(column1),MAX(column2),...
Previous Message Bruce Momjian 2002-04-15 19:13:28 Re: oid and oidvector