composite type and domain

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: composite type and domain
Date: 2009-05-25 16:23:35
Message-ID: 2f4958ff0905250923o5bd8b87asa999a94106cfafca@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Why is it not possible to create domain on composite type ?

Consider the example, I got (a bytea, b timestamp, c timestamp). Where
b < c always, and both b and c have some default value, a can stay
null.
Now, I don't want to go berserk, and create aditional table for that,
because type is shared between two tables. But it would be nice, to be
able to create domain based on that type.
Any reasons I can't , or is it just something I do wrong?

That's on 8.3/8.4

--
GJ

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mARK bLOORE 2009-05-25 19:29:54 how to delete many rows from a huge table?
Previous Message Grzegorz Jaśkiewicz 2009-05-25 15:34:10 Re: Assistance in importing a csv file into Postgresql