Postgres Pro
Downloads
Home   >   mailing lists

Re: Determine actual type of a pseudo-type argument - Mailing list pgsql-general

From Steve Baldwin
Subject Re: Determine actual type of a pseudo-type argument
Date
Msg-id CAKE1AibqmXbC2ozuuFN_P5esnwiw+594wrTNPvM_3ZRRQBJPjA@mail.gmail.com
Whole thread Raw
In response to Determine actual type of a pseudo-type argument  (Gerald Britton <gerald.britton@gmail.com>)
Responses Re: Determine actual type of a pseudo-type argument
List pgsql-general
Tree view
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 <gerald.britton@gmail.com> 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

pgsql-general by date:

Previous
From: Gerald Britton
Date:
Subject: Determine actual type of a pseudo-type argument
Next
From: Tom Lane
Date:
Subject: Re: Are PostgreSQL functions that return sets or tables evaluated lazily or eagerly?