Re: [GENERAL] virtual fields ( proxy execution ?? )

Поиск
Список
Период
Сортировка
От jim@reptiles.org (Jim Mercer)
Тема Re: [GENERAL] virtual fields ( proxy execution ?? )
Дата
Msg-id m10gq03-00080dC@mailbox.reptiles.org
обсуждение исходный текст
Ответ на Re: [GENERAL] virtual fields ( proxy execution ?? )  (paulmoody <paulmoody@onaustralia.com.au>)
Список pgsql-general
> Hi
>     Err maybe that was a bad example. How about this ... I have ( not really )
> a large number of programmable power supplies connected to my remote Linux box
> where the details about each supply are stored in a database.( eg 100 supplies
> = 100 records ). One of the fields in each record might be called voltage. If
> I query a particular field then the current voltage of the supply is returned.
> If I write to that same field then that particular supply would have its
> voltage adjusted to the written value. This would allow me to manipulate the
> power supply parameters using SQL and would be a powerful ( no pun  ) tool for
> doing all sorts of things in response to alarms etc ( including sending email
> ).
>
> Thanks again.

looks like an application for triggers.

--
[ Jim Mercer    Reptilian Research      jim@reptiles.org   +1 416 410-5633 ]
[ The telephone, for those of you who  have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail.            ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]

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

Предыдущее
От: paulmoody
Дата:
Сообщение: Re: [GENERAL] virtual fields ( proxy execution ?? )
Следующее
От: Chris Bitmead
Дата:
Сообщение: Re: [GENERAL] virtual fields ( proxy execution ?? )