Re: Updating

    Bob Pawley wrote:

> I am attempting to use the following code but I get -
> "ERROR: NEW used in query that is not in a rule".
>
> This implies that I create a rule for NEW and OLD (which I haven't
needed
> before).

No, but are you sure you're using these keywords in the context of a
plpgsql function?
Can you post the entire CREATE statement that fails?

> BTW I noticed that Adrian used != . Is this symbol the same as <> ?

Yes it's the same.

Best regards,
--
 Daniel
 PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org