Return-Path: postman 
Delivery-Date: Mon, 11 Oct 93 10:40:54 PDT
Return-Path: postman
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA03023; Mon, 11 Oct 93 10:37:29 -0700
Resent-From: postman (POSTGRES mailing list)
Resent-Message-Id: <9310111737.AA03023@postgres.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: paxson@postgres.Berkeley.EDU
Received: from elysium.CS.Berkeley.EDU by postgres.Berkeley.EDU (5.61/1.29)
	id AA03013; Mon, 11 Oct 93 10:37:22 -0700
Received: from localhost (paxson@localhost) by elysium.CS.Berkeley.EDU (8.1C/8.1B) id KAA06765; Mon, 11 Oct 1993 10:38:17 -0700
Message-Id: <199310111738.KAA06765@elysium.CS.Berkeley.EDU>
To: "Hugh F. Schmidt (608) 262-1839" <HUGH@macc.wisc.edu>
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: aggregate functions ( mean,min,max,etc.) 
Date: Mon, 11 Oct 1993 10:38:17 -0700
From: "Caroline M. Paxson" <paxson@postgres.Berkeley.EDU>
Resent-To: postgres-dist
Resent-Date: Mon, 11 Oct 93 10:37:28 PDT



You write:

>Does anyone know where simple aggregate functions for postgres can be found?
>Things like mean, min, max, range, etc.

Type to the monitor

	retrieve (pg_aggregate.aggname)\g

to find out which aggregate functions have been defined.

Carol Paxson
Postgres group, U.C. Berkeley