Re: Passing enum Parameters to User-defined C-Language Functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Albrecht Dreß <albrecht(dot)dress(at)posteo(dot)de>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Passing enum Parameters to User-defined C-Language Functions
Date: 2023-10-23 17:08:34
Message-ID: 398801.1698080914@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Albrecht =?iso-8859-1?b?RHJl3w==?= <albrecht(dot)dress(at)posteo(dot)de> writes:
> - How would a “mood” parameter be encoded when it is passed to the function?

It's an OID, which you'd have to look up in the pg_enum catalog if
you want to know the string representation.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2023-10-23 17:13:11 Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This
Previous Message Laurenz Albe 2023-10-23 17:06:23 Re: PostgreSQL inheritance vs https://wiki.postgresql.org/wiki/Don%27t_Do_This