Inserting data in composite types!

From: "Rodrigo Sakai" <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Inserting data in composite types!
Date: 2006-11-13 12:37:07
Message-ID: 00fc01c70720$7364c400$4700a8c0@TREEZANTHUS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi, I have a question about how to insert data in composite types!

Imagine the exemple:

CREATE TYPE t_time AS (

a date,

b date

);

CREATE TABLE salary (

salary numeric(10,2),

t_date t_time

);

I know that if I want to insert data in the table SALARY I just have to do
like:

INSERT INTO salary VALUES (1000.00, '(2006/10/10, 2006/12/10)');

But if I have another table:

CREATE TABLE employee (

employee_id int,

name varchar(30),

emp_salary salary

)

How can I insert a single row in this table???

Thanks in advamce!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Shane Ambler 2006-11-13 12:46:14 Re: Inserting data in composite types!
Previous Message Markus Schiltknecht 2006-11-13 12:28:03 Re: Inserting data in composite types!