Hello David,

Thanks for the hint of bucardo add customcols,

I think I am misunderstanding the concept, in your example it will still
sync the data but with different values wouldn't it ? What I am trying to
do is simply ignore a ROW if it meets certain criteria. Is this possible?

Thank you!




On Fri, Sep 13, 2013 at 5:02 PM, David E. Wheeler <[email protected]>wrote:

>
> On Sep 13, 2013, at 8:33 AM, A. David <[email protected]> wrote:
>
> > Remove the customselect parameter. Use the customcols command, instead.
> >     [David Wheeler]
> >
> > Will this allow to have a "WHERE clause" or it will only allow me to do
> "column1, columnN..."
>
> I believe just the latter, but you can use expressions:
>
>     bucardo add customcols public.foobar "select a, upper(b) AS b, CASE c
> WHEN FALSE THEN 0 ELSE 1 END" AS c db=foo
>
> Best,
>
> David
>
>
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general

Reply via email to