| 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 | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| 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
inserted!
How can I get this ID or NAME inside this functions???
Thanks!!!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-06-28 14:59:45 | Re: Creating a new type | 
| Previous Message | Tom Lane | 2006-06-28 03:21:10 | Re: PQexecParams not seeing params |