From: | imad <immaad(at)gmail(dot)com> |
---|---|
To: | rodrigo(dot)sakai(at)zanthus(dot)com(dot)br |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Inserting data in composite types! |
Date: | 2006-11-13 14:09:34 |
Message-ID: | 1f30b80c0611130609s423d017aj1cb8c20b36c47007@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(dot)sakai(at)zanthus(dot)com(dot)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!
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | imad | 2006-11-13 14:29:09 | Re: max (timestamp,timestamp) |
Previous Message | A. Kretschmer | 2006-11-13 14:08:28 | Re: max (timestamp,timestamp) |