Another question about composite types

Поиск
Список
Период
Сортировка
От Rodrigo Sakai
Тема Another question about composite types
Дата
Msg-id 000101c70752$3de4b560$4700a8c0@TREEZANTHUS
обсуждение исходный текст
Ответы Re: Another question about composite types
Список pgsql-sql

  Hi, I need to create a table like:

 

  CREATE TYPE t_salary AS (

    Value numeric(10,2),

    Validity date

  );

 

  CREATE TABLE employee (

     id int,

     name varchar(30),

     salary t_salary[]

  );

 

 

  That is, I need an array of composite type and searching on google I found that is impossible to do it! Is it really impossible? Anyone have do it ?

 

 

 Thanks!

В списке pgsql-sql по дате отправления: