Creating a new type

From: Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Creating a new type
Date: 2002-09-16 10:37:49
Message-ID: 200209161237.49806.ferdinand@telegraafnet.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

How can a create a new type or alias?

I want to create a alias for the text type. The alias name must be blob.
(MySQL type).
The documentation tells me how to create en new type, but don't tell me how to
create the input and output functions.

Type definition:
CREATE TYPE blob (INPUT = blob_in, OUTPUT = blob_out, ELEMENT = text);

Regards,
Ferdinand

Browse pgsql-admin by date

  From Date Subject
Next Message Rafael Mueller 2002-09-16 12:37:13 Re: -i option
Previous Message Terry Yapt 2002-09-16 09:43:08 psql and readline: cursor up....