Zoltan Boszormenyi <[EMAIL PROTECTED]> writes:
> Tom Lane írta:
>> * There is no GENERATED BY DEFAULT AS (expr) in the spec.

> Yes, and because it already exists and called DEFAULT.

No, plain DEFAULT isn't a substitute, because it can't reference the
values of other columns.  I think there is a use-case for an overridable
GENERATED expression, but won't press the point right now.

>> Is anyone familiar with a database that implements SQL-spec generated
>> columns?  Do they actually store the columns?

> David Fuhry answered this question with the advertised intention.

Yeah, that's good to know --- the text of the spec is quite unhelpful
about telling you what they intended ...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

Reply via email to