On Sun, 2 Jul 2023 08:25:12 +0800 jian he <jian.universal...@gmail.com> wrote:
> This is probably not trivial. > In function apply_new_delta_with_count. > > appendStringInfo(&querybuf, > "WITH updt AS (" /* update a tuple if this exists in the view */ > "UPDATE %s AS mv SET %s = mv.%s OPERATOR(pg_catalog.+) diff.%s " > "%s " /* SET clauses for aggregates */ > "FROM %s AS diff " > "WHERE %s " /* tuple matching condition */ > "RETURNING %s" /* returning keys of updated tuples */ > ") INSERT INTO %s (%s)" /* insert a new tuple if this doesn't existw */ > "SELECT %s FROM %s AS diff " > "WHERE NOT EXISTS (SELECT 1 FROM updt AS mv WHERE %s);", > > --------------------- > ") INSERT INTO %s (%s)" /* insert a new tuple if this doesn't existw */ > "SELECT %s FROM %s AS diff " > > the INSERT INTO line, should have one white space in the end? > also "existw" should be "exists" Yes, we should need a space although it works. I'll fix as well as the typo. Thank you. Regards, Yugo Nagata -- Yugo NAGATA <nag...@sraoss.co.jp>