Re: Converting sql anywhere to postgres

From: Russell Rose | Passfield Data Systems <russellrose(at)passfield(dot)co(dot)uk>
To: Guyren Howe <guyren(at)gmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Converting sql anywhere to postgres
Date: 2023-08-16 06:22:27
Message-ID: VI1P191MB0638DF6A32205FA51983F92AF215A@VI1P191MB0638.EURP191.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have just had a quick look at rules and I am not sure how it can be done. Rules still use the concept of NEW and OLD. If my original row has 'myfield' set to 'me' then I don't think I can tell the difference between:

Update mytable set afield='something'
and
Update mytable set afield='something',myfield='me'

Within the rule I think NEW.myfield will be set to 'me' in both cases. Please can you explain how I can tell the difference between the two update statements

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Joseph Krogh 2023-08-16 08:40:29 Re: PostgreSQL and local HDD
Previous Message Olivier Gautherot 2023-08-16 06:12:09 Re: PostgreSQL and local HDD