On Thu, Nov 27, 2003 at 07:48:46AM -0800, Joe Conway wrote:
> Alex Page wrote:
> [...creates enum_gender_in and enum_gender_out as PL/pgSQL functions...]
> According to the docs, you cannot use PL/pgSQL functions for I/O
> conversion functions. See
> http://www.postgresql.org/docs/current/static/plpgsql.html#PLPGSQL-OVERVIEW
> where it says:
> "Except for input/output conversion and calculation functions for
> user-defined types, anything that can be defined in C language
> functions can also be done with PL/pgSQL."
Fair enough; I was looking at the reference manual for 7.3, which
doesn't mention this limitation under either CREATE TYPE or CREATE
FUNCTION. This has changed in 7.4, where the documentation for CREATE
TYPE reads:
"The support functions input_function and output_function are required,
while the functions receive_function and send_function are optional.
Generally these functions have to be coded in C or another low-level
language."
Alex
--
Mail: Alex Page <alex.page@cancer.org.uk>
Real: Systems/Network Assistant, Epidemiology Unit, Oxford
Tel: 01865 302 223 (external) / 223 (internal)
PGP: 8868 21D7 3D35 DD77 9D06 BF0A 0746 2DE6 55EA 367E