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='somethin
| Passfield Data Systems
; pgsql-general@lists.postgresql.org
Subject: Re: Converting sql anywhere to postgres
On 8/15/23 09:43, Georg H. wrote:
> Hi,
>
> Am 15.08.2023 um 17:04 schrieb Russell Rose | Passfield Data Systems:
>>
>> Hi there
>>
>> I am trying t
Hi there
I am trying to convert a SQL Anywhere database to postgres. Within SQL anywhere
a field can have a default value of 'last user'. This means that when you
perform an update on a table, if the field is not explicitly set then the
current user is used. So for instance if I have a field ca
