Extend phrase by an example

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: kes-kes(at)yandex(dot)ru
Subject: Extend phrase by an example
Date: 2018-09-08 11:56:37
Message-ID: 153640779702.23141.377057841943706781@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/static/rowtypes.html
Description:

Hi.
On the page:
https://www.postgresql.org/docs/10/static/rowtypes.html

>then the same inventory_item composite type shown above would come into
being as a byproduct, and could be used just as above. Note however an
important restriction of the current implementation: since no constraints
are associated with a composite type, the constraints shown in the table
definition do not apply to values of the composite type outside the table.
(A partial workaround is to use domain types as members of composite
types.)

The part:
>(A partial workaround is to use domain types as members of composite
types.)

From here I can understand that workaround is possible.

But what is workaround? and why it is partial?
Would be great to have this description.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2018-09-08 13:27:14 Extend example of JOIN results for completeness
Previous Message Justin Pryzby 2018-09-08 01:29:57 link to Slow_Query_Questions from wiki/Main Page