Re: I need help creating a composite type with some sort of constraints.

Поиск
Список
Период
Сортировка
От John Oyler
Тема Re: I need help creating a composite type with some sort of constraints.
Дата
Msg-id 3cc9797c0911240713k1b74c1f0g5d305c3b8cf28cca@mail.gmail.com
обсуждение исходный текст
Ответы Re: Re: I need help creating a composite type with some sort of constraints.
Список pgsql-general
John Oyler wrote:

   I can create one or more domains, and use those to create the
   composite type from. But each domain can only be constrained in its
   own value, I can't constrain element #1's value based on what element
   #2's value is.

   If I create a domain from a composite, it will complain with a "ERROR:
   cdt.instant_message is not a valid base type for a domain" error.

   I can't create a trigger for a composite either (technically it's not
   a table, but I was hoping it might be treated as one internally).

   Is there any way to do this? Are there any plans to change or expand
   this functionality in the future?

   Thanks,
   John O.

For now you have to put all checks in custom constructor functions.

Scott

I must not be looking in the right place... the only thing I can find that seems remotely related, is the page on input/output functions for custom types. And I was under the impression that only applies to non-composite custom types. Did I miss something?

Thanks,
John O.

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

Предыдущее
От: Kurt
Дата:
Сообщение: exclude table from transactions
Следующее
От: Denis Lussier
Дата:
Сообщение: Re: [PERFORM] Strange performance degradation