Hello! Question is what's the easiest way to implement conditional execution of insert/update-s via psql interface? As far as I know there's following options: 1) create function in procedural language (plpgsql, for example); then call that function 2) update ... where <conditon>; insert ... (select ... where <condition>); not sure here if <condition> can be unrelated to the table being modified by update/insert statement; Are there alternatives? -- A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? A: Top-posting. Q: What is the most annoying thing in e-mail? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general