|
3 | 3 | * |
4 | 4 | * Copyright 2000-2002 by PostgreSQL Global Development Group |
5 | 5 | * |
6 | | - * $Header: /cvsroot/pgsql/src/bin/psql/describe.c,v 1.70 2002/10/15 02:24:16 tgl Exp $ |
| 6 | + * $Header: /cvsroot/pgsql/src/bin/psql/describe.c,v 1.71 2002/10/19 20:50:44 tgl Exp $ |
7 | 7 | */ |
8 | 8 | #include"postgres_fe.h" |
9 | 9 | #include"describe.h" |
@@ -119,9 +119,10 @@ describeFunctions(const char *pattern, bool verbose) |
119 | 119 | initPQExpBuffer(&buf); |
120 | 120 |
|
121 | 121 | printfPQExpBuffer(&buf, |
122 | | -"SELECT pg_catalog.format_type(p.prorettype, NULL) as \"%s\",\n" |
123 | | -" n.nspname as \"%s\",\n" |
124 | | -" p.proname as \"%s\",\n" |
| 122 | +"SELECT CASE WHEN p.proretset THEN 'setof ' ELSE '' END ||\n" |
| 123 | +" pg_catalog.format_type(p.prorettype, NULL) as \"%s\",\n" |
| 124 | +" n.nspname as \"%s\",\n" |
| 125 | +" p.proname as \"%s\",\n" |
125 | 126 | " pg_catalog.oidvectortypes(p.proargtypes) as \"%s\"", |
126 | 127 | _("Result data type"),_("Schema"),_("Name"), |
127 | 128 | _("Argument data types")); |
|