diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-04-12 04:26:34 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-04-12 04:26:34 +0000 |
| commit | 2e7a68896bfa84b28cd57e23e141aa9c899275c7 (patch) | |
| tree | 11d360de8f7aab0d5c3345a45e61169c40f83538 /src/backend/commands/aggregatecmds.c | |
| parent | 3803f243790466722cb6cd26118f48629261cb58 (diff) | |
| download | postgresql-2e7a68896bfa84b28cd57e23e141aa9c899275c7.tar.gz postgresql-2e7a68896bfa84b28cd57e23e141aa9c899275c7.zip | |
Add aggsortop column to pg_aggregate, so that MIN/MAX optimization can
be supported for all datatypes. Add CREATE AGGREGATE and pg_dump support
too. Add specialized min/max aggregates for bpchar, instead of depending
on text's min/max, because otherwise the possible use of bpchar indexes
cannot be recognized.
initdb forced because of catalog changes.
Diffstat (limited to 'src/backend/commands/aggregatecmds.c')
| -rw-r--r-- | src/backend/commands/aggregatecmds.c | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/src/backend/commands/aggregatecmds.c b/src/backend/commands/aggregatecmds.c index 7d4cbe36422..32bf25389a4 100644 --- a/src/backend/commands/aggregatecmds.c +++ b/src/backend/commands/aggregatecmds.c @@ -9,7 +9,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/commands/aggregatecmds.c,v 1.23 2005/03/29 00:16:57 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/commands/aggregatecmds.c,v 1.24 2005/04/12 04:26:20 tgl Exp $ * * DESCRIPTION * The "DefineFoo" routines take the parse tree and pick out the @@ -51,6 +51,7 @@ DefineAggregate(List *names, List *parameters) AclResult aclresult; List *transfuncName = NIL; List *finalfuncName = NIL; + List *sortoperatorName = NIL; TypeName *baseType = NULL; TypeName *transType = NULL; char *initval = NULL; @@ -81,6 +82,8 @@ DefineAggregate(List *names, List *parameters) transfuncName = defGetQualifiedName(defel); else if (pg_strcasecmp(defel->defname, "finalfunc") == 0) finalfuncName = defGetQualifiedName(defel); + else if (pg_strcasecmp(defel->defname, "sortop") == 0) + sortoperatorName = defGetQualifiedName(defel); else if (pg_strcasecmp(defel->defname, "basetype") == 0) baseType = defGetTypeName(defel); else if (pg_strcasecmp(defel->defname, "stype") == 0) @@ -143,9 +146,10 @@ DefineAggregate(List *names, List *parameters) */ AggregateCreate(aggName, /* aggregate name */ aggNamespace, /* namespace */ + baseTypeId, /* type of data being aggregated */ transfuncName, /* step function name */ finalfuncName, /* final function name */ - baseTypeId, /* type of data being aggregated */ + sortoperatorName, /* sort operator name */ transTypeId, /* transition data type */ initval); /* initial condition */ } |