Re: [HACKERS] Creating operators - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: [HACKERS] Creating operators
Date
Msg-id 380DBAC2.42BAC78C@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] Creating operators  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > Can I create an operator '::', such as <my own type>::double ?

This brings up something: I see mention in Date and Darwen of an SQL3
enumerated type. Nice feature, but they show the syntax being:
 <type>::<value>

which reuses the "::" operator in a way which may be incompatible with
Postgres' usage (seems to me to have the fields reversed). btw, I
could imagine implementing enumerated types as Postgres arrays or as a
separate table per type.

Has anyone come across this SQL3 feature yet? Any opinions??
                  - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Readline use in trouble?
Next
From: Thomas Lockhart
Date:
Subject: Re: PostgreSQL Perl Module