Postgres Pro
Downloads
Home   >   mailing lists

Thread: CREATE TYPE

CREATE TYPE

From
"Rodrigo Sakai"
Date:
  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!

Re: CREATE TYPE

From
"Shoaib Mir"
Date:
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@zanthus.com.br> 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!