Re: CREATE TYPE

["Shoaib Mir" <shoaibmir@xxxxxxxxx>]

You can have a looks at http://www.postgresql.org/docs/8.1/static/sql-createtype.html

Regards
/Shoaib

On 4/27/06, Rodrigo Sakai <rodrigo.sakai@xxxxxxxxxxxxxx> wrote:

  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!