use of a composite type in CREATE TABLE?

Поиск
Список
Период
Сортировка
От Hannes Korte
Тема use of a composite type in CREATE TABLE?
Дата
Msg-id 40D179F4.3090901@hkorte.com
обсуждение исходный текст
Ответы Re: use of a composite type in CREATE TABLE?
Re: use of a composite type in CREATE TABLE?
Список pgsql-sql
Hi,

does anyone know how it is posible to set a composite type as the data 
type of a column when creating a new table?

CREATE TABLE tbl1 (
name VARCHAR(60) NOT NULL,
address comp_type_address
);

The exmaple above does not work.
Any help is appreciated.

-- 
Regards,
Hannes


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