| From: | Gerald Britton <gerald(dot)britton(at)gmail(dot)com> |
|---|---|
| To: | Steve Baldwin <steve(dot)baldwin(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Determine actual type of a pseudo-type argument |
| Date: | 2020-01-05 22:54:13 |
| Message-ID: | CAPxRSnZTwqp-nR38SYaty0DQjFaT1b_cB4hWzQLDvjppzH90SQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 <steve(dot)baldwin(at)gmail(dot)com> 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 <gerald(dot)britton(at)gmail(dot)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
>>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Lissner | 2020-01-06 17:19:17 | Re: How to shorten a chain of logically replicated servers |
| Previous Message | Tom Lane | 2020-01-05 22:46:06 | Re: Are PostgreSQL functions that return sets or tables evaluated lazily or eagerly? |