3 ms·
From the article: > ” Such functionality was earlier usually achieved with triggers, but with generated columns this becomes much more elegant and cleaner.”
by grzm 7y ago
From the article:
> ” Such functionality was earlier usually achieved with triggers, but with generated columns this becomes much more elegant and cleaner.”
- ako 7y ago"much more elegant and cleaner" is a bit of an overstatement in my opinion...
- grzm 7y agoSounds like the generated column implementation is faster than a PL/pgSQL trigger. https://news.ycombinator.com/item?id=21134706 https://news.ycombinator.com/item?id=21134706 I don’t have a link at hand from a discussion on the mailing list, but I’ll take Peter’s word for it.
- mobilemidget 7y agoI miss the why its more elegant and cleaner too. "Indexes: Generated columns can be used in indexes, but cannot be used as a partition key for partitioned tables." I also hope it can be used for a partition key in the future.