On Jan 9, 2008 4:53 AM, R.A. <adeveloper@bluebottle.com> wrote:
> Hello,
>
> I'm trying to create a composite type with an argument, to create one field of this type like character varying(x),
butI don't know if this can be done with PostgreSQL. I want something like:
> CREATE TYPE mytype AS (
> tx character varying(x),
> t2nd integer
> );
> I need to limit the number of chars in this field tx. And different lengths will be used when creating tables with
thistype (so a Domain will suffer the same problem). I'm not looking for a solution like a separate column with
maxCharsand a Check, because lots of columns will be required (and others design reasons).
It would be really neat if you could do that, but you can't :-(. What
you can do is make a trigger function taking mytype which and apply
the constraint that way...
merlin
