Re: [GENERAL] Inserting data in composite types

2006-11-13 Thread Jeff Davis
On Mon, 2006-11-13 at 09:37 -0300, Rodrigo Sakai 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),

Re: [GENERAL] Inserting data in composite types

2006-11-13 Thread Albe Laurenz
> Hi, I have a question about how to insert data in composite types! > > 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: > >

[GENERAL] Inserting data in composite types

2006-11-13 Thread Rodrigo Sakai
  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