Re: CREATE TYPE

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(dot)sakai(at)zanthus(dot)com(dot)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!
>