| From: | Leif Biberg Kristensen <leif(at)solumslekt(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Rules and conditions |
| Date: | 2009-12-09 09:07:26 |
| Message-ID: | 200912091007.26652.leif@solumslekt.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Tyler | 2009-12-09 11:24:38 | Re: Excessive (and slow) fsync() within single transaction |
| Previous Message | Dan Kortschak | 2009-12-09 08:19:17 | Re: how to ensure a client waits for a previous transaction to finish? |