Re: Opaque not working as documented

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steven Blundy <sblundy(at)CLEMSON(dot)EDU>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Opaque not working as documented
Date: 2002-06-21 20:54:32
Message-ID: 28653.1024692872@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Steven Blundy <sblundy(at)CLEMSON(dot)EDU> writes:
> Changing opaque to text results in the CREATE FUNCTION statements
> working, while the CREATE TYPE statements throw a fit.

Yup. You cannot use SQL functions to write I/O operations for a new
datatype, because the I/O converters run at a lower logical level than
SQL. The only way to code them is in C.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Eric Naujock 2002-06-23 17:18:00 Reliable and scrptable backup to Postgresql databases.
Previous Message Bruce Momjian 2002-06-21 19:57:29 Re: ISAM access in PostgreSQL?