Skip site navigation (1) Skip section navigation (2)

Re: CREATE TYPE

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: CREATE TYPE
Date: 2006-04-27 11:04:32
Message-ID: bf54be870604270404h7135c248mc9719856fc3df5a6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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!
>

In response to

  • CREATE TYPE at 2006-04-27 10:45:39 from Rodrigo Sakai

pgsql-general by date

Next:From: Kenneth DownsDate: 2006-04-27 11:05:00
Subject: Re: SQL Rule
Previous:From: Rodrigo SakaiDate: 2006-04-27 10:45:39
Subject: CREATE TYPE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group