RES: Inserting data in composite types!
От | Rodrigo Sakai |
---|---|
Тема | RES: Inserting data in composite types! |
Дата | |
Msg-id | 000001c70751$5cae7130$4700a8c0@TREEZANTHUS обсуждение исходный текст |
Ответ на | Re: Inserting data in composite types! (imad <immaad@gmail.com>) |
Ответы |
Re: RES: Inserting data in composite types!
|
Список | pgsql-sql |
Thanks, It works! I have tried: insert into employee (c, nome, sal) values(1, 'emp name', '(1, (01/01/2000, 01/01/2000))' ); And it doesn't work! -----Mensagem original----- De: imad [mailto:immaad@gmail.com] Enviada em: segunda-feira, 13 de novembro de 2006 11:10 Para: rodrigo.sakai@zanthus.com.br Cc: pgsql-sql@postgresql.org Assunto: Re: [SQL] Inserting data in composite types! I am able to do this thing with the following query: insert into employee (a, name, s) values(1, 'emp name', ((1, '(01/01/2000, 01/01/2000)'))); --Imad www.EnterpriseDB.com On 11/13/06, Rodrigo Sakai <rodrigo.sakai@zanthus.com.br> wrote: > > > > > 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 по дате отправления: