diff options
Diffstat (limited to 'src/interfaces/python/tutorial/syscat.py')
| -rwxr-xr-x | src/interfaces/python/tutorial/syscat.py | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/src/interfaces/python/tutorial/syscat.py b/src/interfaces/python/tutorial/syscat.py index 179f3ef6a3e..d2c6e44657e 100755 --- a/src/interfaces/python/tutorial/syscat.py +++ b/src/interfaces/python/tutorial/syscat.py @@ -101,10 +101,11 @@ def list_lang_func(pgcnx, l): # lists all the aggregate functions and the type to which they can be applied def list_agg_func(pgcnx): - result = pgcnx.query("""SELECT a.aggname, t.typname - FROM pg_aggregate a, pg_type t - WHERE a.aggbasetype = t.oid - ORDER BY aggname, typname""") + result = pgcnx.query("""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""") return result # lists all the operator classes that can be used with each access method as |