Re: [GENERAL] virtual fields ( proxy execution ?? ) - Mailing list pgsql-general

From jim@reptiles.org (Jim Mercer)
Subject Re: [GENERAL] virtual fields ( proxy execution ?? )
Date
Msg-id m10gq03-00080dC@mailbox.reptiles.org
Whole thread Raw
In response to Re: [GENERAL] virtual fields ( proxy execution ?? )  (paulmoody <paulmoody@onaustralia.com.au>)
List 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 by date:

Previous
From: paulmoody
Date:
Subject: Re: [GENERAL] virtual fields ( proxy execution ?? )
Next
From: Chris Bitmead
Date:
Subject: Re: [GENERAL] virtual fields ( proxy execution ?? )