diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-06-26 22:05:42 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-06-26 22:05:42 +0000 |
| commit | 943b396245bd699a66c894c5e11303b3ef93ac7b (patch) | |
| tree | a08720e308259beb253e4b4b21f2f08e391a4d9f /src/backend/parser/parse_target.c | |
| parent | d395aecffad7cc6bd043e2d81a1bed5b3fe2f5fa (diff) | |
| download | postgresql-943b396245bd699a66c894c5e11303b3ef93ac7b.tar.gz postgresql-943b396245bd699a66c894c5e11303b3ef93ac7b.zip | |
Add Oracle-compatible GREATEST and LEAST functions. Pavel Stehule
Diffstat (limited to 'src/backend/parser/parse_target.c')
| -rw-r--r-- | src/backend/parser/parse_target.c | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/src/backend/parser/parse_target.c b/src/backend/parser/parse_target.c index dd2c0b4e31c..00185a05e12 100644 --- a/src/backend/parser/parse_target.c +++ b/src/backend/parser/parse_target.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/parser/parse_target.c,v 1.136 2005/06/05 00:38:10 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/parser/parse_target.c,v 1.137 2005/06/26 22:05:40 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -1123,6 +1123,18 @@ FigureColnameInternal(Node *node, char **name) /* make coalesce() act like a regular function */ *name = "coalesce"; return 2; + case T_MinMaxExpr: + /* make greatest/least act like a regular function */ + switch (((MinMaxExpr*) node)->op) + { + case IS_GREATEST: + *name = "greatest"; + return 2; + case IS_LEAST: + *name = "least"; + return 2; + } + break; default: break; } |