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),
> 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:
>
>
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