Re: lack of consequence with domains and types - Mailing list pgsql-general

On Fri, Dec 26, 2008 at 3:57 PM, Grzegorz Jaśkiewicz <gryzman@gmail.com> wrote:
> another glance at source code, and docs tells me - that there's not
> such thing as default value for custom type - unless that type is
> defined as new base scalar type. So probably, that would require
> postgresql to allow users to define default values for composite types
> as well, like that:
> create type foo AS
> (
>  a int default 1,
>  b foodomain default 'foo',
> ....
> );

don't forget, you can create types via create table:

create table foo as
(
  a int default 1,
  ...
  check (a<5)
);

create table bar(f foo);
insert into bar default values; -- should foo defaults fire?? I say
probably, but check constraints should definately be enforced
(currently they are not).

(since you can alter the table later, there is very little reason not
to create types with create table always).

merlin