Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group