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

Creating a new type

From: "Rodrigo Sakai" <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Creating a new type
Date: 2006-06-28 14:49:56
Message-ID: 002a01c69ac2$1f2a8110$4700a8c0@TREEZANTHUS (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
  Hi all,


  I have to create a new composed data type to use in almost all tables of
my database. Something like:


  CREATE TYPE time_interval (

    Tbegin date,

    Tend date




  And when use this new type in my tables! So, I have to be able to get the
table_name or table_id that the type is in. For exemple:


  CREATE TABLE employee (

    Emp_id int,

    Emp_name varchar(30),

    Emp_time time_interval



  So, when I execute an INSERT operation on this table, the functions that
deals with this type need the id or name of the table that the data was

  How can I get this ID or NAME inside this functions??? 






pgsql-interfaces by date

Next:From: Tom LaneDate: 2006-06-28 14:59:45
Subject: Re: Creating a new type
Previous:From: Tom LaneDate: 2006-06-28 03:21:10
Subject: Re: PQexecParams not seeing params

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