"Richard Huxton" <dev@xxxxxxxxxxxx> a következőket írta üzenetében
news:49393A81.3030702@xxxxxxxxxxxxxxx
Csaba Együd wrote:
Thx for your reply. Is there any possible way to generate an sql to
"copy" these defaults to the view.
Nothing pre-packaged that I know of. You could probably do something
copying values about in pg_attribute and pg_constraint, but that'd be an
"at your own risk" sort of activity I suspect.
For simpler defaults etc. you could probably get what you need from
information_schema.columns
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Or use of coalesce() function???
I mean sg like:
..., qtyunitid = coalesce(NEW.qtyunitid, -1), ...
in the Rule def.
-- Csaba
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
