CREATE TYPE

["Rodrigo Sakai" <rodrigo.sakai@xxxxxxxxxxxxxx>]

  Hi all,

 

  I need some help to create types to use in a table. For exemple, I want to create:

 

 

  CREATE TYPE salary_type (

    value NUMERIC(10,2),

    date  DATE

  )

 

 

 CREATE TABLE employee (

    num_employee INT,

    name VARCHAR(60),

    salary  salary_type

  )

 

 

 

  I know I need two functions written in C (input_function, output_function). So, anyone can show me an example of this functions for my type salary_type?

 

  Thanks!