Creating a 'SET' type - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Creating a 'SET' type
Date
Msg-id NEBBIOAJBMEENKACLNPCKEKJCCAA.chriskl@familyhealth.com.au
Whole thread Raw
Responses Re: Creating a 'SET' type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

I am trying to emulate MySQL's SET type, by creating a new postgresql type.

However, is it possible to create a type that has different parameters
wherever it is used.

For instance - the varchar type takes as a parameter the max characters in
the field.  Although there is only one varchar type, it has different
properties depending on whether or not it is varchar(5) or varchar(20).

I wish to be able to declare:

bitset('LOW','MEDIUM','HIGH')  // Not sure of exact syntax

Internally stored as an int4.

The trouble is in writing the in and out functions.  They need to be able to
store a list of token names in order to recreate the comma delimited list of
tokens from the internal bitset, and vice versa...

Any help?

Thanks,

Chris

--
Christopher Kings-Lynne
Family Health Network (ACN 089 639 243)



pgsql-hackers by date:

Previous
From: Vincent AE Scott
Date:
Subject: Re: external function proposal for 7.2
Next
From: Horst Herb
Date:
Subject: Re: RFC: CRC datatype