| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | "Neil Conway" <nconway(at)klamath(dot)dyndns(dot)org>, "Patches" <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: pg_stat_reset round 3 |
| Date: | 2002-08-06 06:08:58 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOKEIJCDAA.chriskl@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
> Interesting that all callable function must return a type. I did:
>
> test=> select proname from pg_proc where prorettype = 0;
>
> and none of the functions with 0 prorettype can be called from psql. I
> guess boolean is the best we can do. I guess because it is a function
> it has to return something.
Yeah, because otherwise what does the SELECT return? It has to return at
least one column? It would be odd to just go SELECT blah() and have the
prompt just come back to you. However, it would be nice to be able to go
"CALL blah()" and have it return nothing except maybe a 'CALL' string.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2002-08-06 06:12:51 | Re: pg_stat_reset round 3 |
| Previous Message | Bruce Momjian | 2002-08-06 06:02:16 | Re: pg_stat_reset round 3 |