Обсуждение: insert data of composite type

Поиск
Список
Период
Сортировка

insert data of composite type

От
"shiyuan"
Дата:
Dear Sir:
  We have created a table with a column of composite type.
  how can we insert values in this table.
 for exemple:
 create table aa (a int);
 create tabel bb (b aa);

how to insert data  into bb??
   Thank you!

=============================================================
�������佡��ɱ�����ж���
�������ľ��� ��ס���ľ��� ����ȫ���շѣ�
����վ����������ѧ��������

Re: insert data of composite type

От
Greg Stark
Дата:
"shiyuan" <shizhao111@163.com> writes:

> Dear Sir:
>   We have created a table with a column of composite type.
>   how can we insert values in this table.
>  for exemple:
>  create table aa (a int);
>  create tabel bb (b aa);
>
> how to insert data  into bb??

I wasn't even aware you could do this.

One area this would be really handy is for audit tables. Instead of having to
copy every column over to the audit log, and have to write out tedious
triggers to insert every column, the logging triggers could simply insert the
whole record as one column.

How do you work with such datatypes?

--
greg