Inserting data in composite types!
| От | Rodrigo Sakai |
|---|---|
| Тема | Inserting data in composite types! |
| Дата | |
| Msg-id | 00fc01c70720$7364c400$4700a8c0@TREEZANTHUS обсуждение исходный текст |
| Ответы |
Re: Inserting data in composite types!
Re: Inserting data in composite types! Re: Inserting data in composite types! |
| Список | 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!
В списке pgsql-sql по дате отправления: