Re: [HACKERS] Enum type emulation: problem with opaque type in PL/pgSQL functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Max Fonin <fonin(at)ziet(dot)zhitomir(dot)ua>
Cc: hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Enum type emulation: problem with opaque type in PL/pgSQL functions
Date: 2000-11-23 16:13:28
Message-ID: 7060.974996008@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Max Fonin <fonin(at)ziet(dot)zhitomir(dot)ua> writes:
> I guess the problem is that PL/pgSQL doesn't handle opaque type correctly.

No it doesn't, which is not surprising considering that opaque isn't
really a type at all. The error message could be improved though :-(

Currently I believe that the only way to write datatype I/O routines
is to do it in C, because what they really need to deal in is C-style
strings, and those are not an SQL-level type.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steffen Schmidt 2000-11-23 16:27:23 Re: Running several postmaster using same database in parallel
Previous Message Don Baccus 2000-11-23 15:58:29 Re: [HACKERS] Re: PHPBuilder article -- Postgres vs MySQL

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Brown 2000-11-23 23:55:32 Re: RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.c xlog.c)
Previous Message Don Baccus 2000-11-23 15:58:29 Re: [HACKERS] Re: PHPBuilder article -- Postgres vs MySQL