CREATE TYPE - Mailing list pgsql-general

From Rodrigo Sakai
Subject CREATE TYPE
Date
Msg-id 003301c669e7$b9c07ec0$4700a8c0@TREEZANTHUS
Whole thread Raw
Responses Re: CREATE TYPE
List pgsql-general
  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!

pgsql-general by date:

Previous
From: "Michael Artz"
Date:
Subject: Re: Disk Failure Scenarios
Next
From: "Shoaib Mir"
Date:
Subject: Re: CREATE TYPE