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