Would it be possible to have a " Column value filtering in Logical Replication ", on the publication side ? Il would not be a " Column Filtering " neither a " row filtering ". It would be the possibility to send NULL (instead of the column value, for a publication table), when a where clause is unsatisfied. In others terms, a way to filter column values according to a logical condition.
CREATE PUBLICATION <pub_name> [ FOR TABLE [ONLY] table_name [(colname [,…]) [WHERE (<where_clause>)] ] would become : CREATE PUBLICATION <pub_name> [ FOR TABLE [ONLY] table_name [(colname [WHERE (<col_where_clause>)] [,…]) [WHERE (<row_where_clause>)] ] -> The " col_where_clause " could be a where clause to filter or better a function to transform the column values.
For example, with a col_where_clause (for column b) as : " b <= 50 "
On publisher : a | b -----+------ 111 | 44.4 222 | 55.5 333 | 33.3
on subscriber : a | b -----+------ 111 | 44.4 222 | 333 | 33.3
