W dniu 01/01/2013 07:24 PM, Adrian Klaver pisze:
On 01/01/2013 10:17 AM, Rafał Pietrak wrote:
[---------------]
If not, I think having OLD.* in INSERT rules/triggers is worth
pondering.
The thing is, that it would be a valuable tool to mimic table-propper
functionality by a view. The OLD.* preudorelation on INSERT could
provide column defaults from the underlaying table definition.
[----------------]
http://www.postgresql.org/docs/9.2/interactive/sql-alterview.html
"SET/DROP DEFAULT
These forms set or remove the default value for a column. A default
value associated with a view column is inserted into INSERT statements
on the view before the view's ON INSERT rule is applied, if the INSERT
does not specify a value for the column."
Aha. I felt, I was missing something.
It is not quite the same, but close.
It's not the same, as one has to keep track of the default value for one
thing in two places; but it's surely better then nothing (as I thought,
was the case).
thenx again,
-R
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
