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 по дате отправления: