On Wednesday 9. December 2009 09.06.12 Guillaume Lelarge wrote: > Le mercredi 9 décembre 2009 à 01:52:03, George Silva a écrit : > > [...] > > I can't seem to understand why a simples if is not working on the > > creation of rules. > > > > I tried both ways (am i missing something?): > > > > Sure. IF does not exist in SQL, and you can only put SQL statements in a rule. > Instead, you can call a stored function written in PL/pgsql which supports IF > structure. Or you can look up the CASE WHEN ... THEN ... ELSE .. END, construct, which works very much like IF / THEN / ELSE: <http://www.postgresql.org/docs/current/static/functions-conditional.html> -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
