Re: Empty Updates, ON UPDATE triggers and Rules

From: Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Empty Updates, ON UPDATE triggers and Rules
Date: 2009-08-06 22:33:24
Message-ID: 20090806173324.49bd1dce@prokofiev.trutwins.homeip.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 6 Aug 2009 16:58:02 -0400
Michael Glaesemann <grzm(at)seespotcode(dot)net> wrote:

> That's not a SELECT query per se: AIUI it's how the evaluation of
> the NEW != OLD expression is evaluated within the PL/pgSQL function
> as part of the IF statement (note the "line 2 at IF" context line).
> It's just saying the <> operator doesn't exist for the test_upd
> rowtype.

Oops - that was a typo - meant to say UPDATE.

Thx,

Josh

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brendan Hill 2009-08-07 01:14:06 Re: Idle processes chewing up CPU?
Previous Message Stephan Szabo 2009-08-06 21:47:40 Re: Foreign Key Deferrable Misunderstanding or Bug?