diff options
Diffstat (limited to 'src/test/regress/sql/create_aggregate.sql')
| -rw-r--r-- | src/test/regress/sql/create_aggregate.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/src/test/regress/sql/create_aggregate.sql b/src/test/regress/sql/create_aggregate.sql index 5d42ed057e3..4188760c87c 100644 --- a/src/test/regress/sql/create_aggregate.sql +++ b/src/test/regress/sql/create_aggregate.sql @@ -9,6 +9,11 @@ CREATE AGGREGATE newavg ( initcond1 = '{0,0,0}' ); +-- test comments +COMMENT ON AGGREGATE newavg_wrong (int4) IS 'an agg comment'; +COMMENT ON AGGREGATE newavg (int4) IS 'an agg comment'; +COMMENT ON AGGREGATE newavg (int4) IS NULL; + -- without finalfunc; test obsolete spellings 'sfunc1' etc CREATE AGGREGATE newsum ( sfunc1 = int4pl, basetype = int4, stype1 = int4, @@ -21,3 +26,6 @@ CREATE AGGREGATE newcnt ( initcond = '0' ); +COMMENT ON AGGREGATE nosuchagg (*) IS 'should fail'; +COMMENT ON AGGREGATE newcnt (*) IS 'an any agg comment'; +COMMENT ON AGGREGATE newcnt (*) IS NULL; |