Subject | is there a support for "create type" like postgresql ? |
---|---|
Author | ik |
Post date | 2011-12-25T13:51:24Z |
Hello,
Firebird have support for "create domain" that allow me to create a
new type out from existed type.
PostgreSQL support this as well, but it also support "create type"
(http://www.postgresql.org/docs/8.3/static/rowtypes.html)
that allow to create more complex data types such as "struct" in C or
"records" in Pascal, like so:
CREATE TYPE DateDetails AS (
ADate Date,
ATime Time,
ATimeZone TimeZone,
Epoch TIMESTAMP
);
It also seems to be supported in some-way by MS SQL-Server.
Is there any Firebird equivalent for this one ?
Thanks,
Ido
Firebird have support for "create domain" that allow me to create a
new type out from existed type.
PostgreSQL support this as well, but it also support "create type"
(http://www.postgresql.org/docs/8.3/static/rowtypes.html)
that allow to create more complex data types such as "struct" in C or
"records" in Pascal, like so:
CREATE TYPE DateDetails AS (
ADate Date,
ATime Time,
ATimeZone TimeZone,
Epoch TIMESTAMP
);
It also seems to be supported in some-way by MS SQL-Server.
Is there any Firebird equivalent for this one ?
Thanks,
Ido