Re: Determine actual type of a pseudo-type argument
Gerald Britton <[email protected]> Sun, 5 Jan 2020 17:54:13 -0500
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <CAPxRSnZTwqp-nR38SYaty0DQjFaT1b_cB4hWzQLDvjppzH90SQ@mail.gmail.com> |
E.g. anyelement, anyenum, anyarray are in a table of pseudo types in the official docs. I'll try pg_typeof...looks like a possibility. On Sun, Jan 5, 2020, 5:37 PM Steve Baldwin <[email protected]> wrote: > I'm not sure what you mean by pseudo-type, but does the pg_typeof() > function help? > > Steve > > On Mon, Jan 6, 2020 at 9:34 AM Gerald Britton <[email protected]> > wrote: > >> If I use a pseudo-type in the argument list of a function definition (SQL >> or plpgsql), how can I determine the actual type used a runtime? >> >> -- >> Gerald Britton, MCSE-DP, MVP >> LinkedIn Profile: http://ca.linkedin.com/in/geraldbritton >> >