From 902a6a0a4bc62d619a5ccd1ef0ff7fb3a5d897f1 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 11 Apr 2002 20:00:18 +0000 Subject: Restructure representation of aggregate functions so that they have pg_proc entries, per pghackers discussion. This fixes aggregates to live in namespaces, and also simplifies/speeds up lookup in parse_func.c. Also, add a 'proimplicit' flag to pg_proc that controls whether a type coercion function may be invoked implicitly, or only explicitly. The current settings of these flags are more permissive than I would like, but we will need to debate and refine the behavior; for now, I avoided breaking regression tests as much as I could. --- src/tutorial/syscat.source | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'src/tutorial/syscat.source') diff --git a/src/tutorial/syscat.source b/src/tutorial/syscat.source index f1be25728ca..a43277f45d1 100644 --- a/src/tutorial/syscat.source +++ b/src/tutorial/syscat.source @@ -7,7 +7,7 @@ -- Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group -- Portions Copyright (c) 1994, Regents of the University of California -- --- $Id: syscat.source,v 1.5 2001/08/21 16:36:06 tgl Exp $ +-- $Id: syscat.source,v 1.6 2002/04/11 20:00:18 tgl Exp $ -- --------------------------------------------------------------------------- @@ -129,10 +129,11 @@ SELECT p.proname, p.pronargs, t.typname -- -- lists all aggregate functions and the types to which they can be applied -- -SELECT a.aggname, t.typname - FROM pg_aggregate a, pg_type t - WHERE a.aggbasetype = t.oid - ORDER BY aggname, typname; +SELECT p.proname, t.typname + FROM pg_aggregate a, pg_proc p, pg_type t + WHERE a.aggfnoid = p.oid + and p.proargtypes[0] = t.oid + ORDER BY proname, typname; -- -- cgit v1.2.3