Re: Virtual generated columns

On 10.11.24 04:16, Amit Kapila wrote:
> The possible idea to replicate virtual generated columns is to compute
> the corresponding expression before sending the data to the client. If
> we can allow it in the row filter than why not to publish it as well.

Row filters have pretty strong restrictions for what kind of operations
they can contain. Applying those restrictions to virtual generated
columns would probably not make that feature very useful. (You want to
use virtual columns for expressions that are too cumbersome to write out
by hand every time.)

Moreover, we would have to implement some elaborate cross-checks if a
table gets added to a publication. How would that work? "Can't add
table x to publication because it contains a virtual generated column
with a non-simple expression"? With row filters, this is less of a
problem, because the row filter a property of the publication.