Re: Converting sql anywhere to postgres

Поиск
Список
Период
Сортировка
От Russell Rose | Passfield Data Systems
Тема Re: Converting sql anywhere to postgres
Дата
Msg-id VI1P191MB0638DF6A32205FA51983F92AF215A@VI1P191MB0638.EURP191.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на Converting sql anywhere to postgres  (Russell Rose | Passfield Data Systems <russellrose@passfield.co.uk>)
Ответы Re: Converting sql anywhere to postgres
Список 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.
Ifmy 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
differencebetween the two update statements 




В списке pgsql-general по дате отправления:

Предыдущее
От: Olivier Gautherot
Дата:
Сообщение: Re: PostgreSQL and local HDD
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: PostgreSQL and local HDD