| From: | jim(at)reptiles(dot)org (Jim Mercer) |
|---|---|
| To: | paulmoody(at)onaustralia(dot)com(dot)au (paulmoody) |
| Cc: | chris(dot)bitmead(at)bigfoot(dot)com, pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] virtual fields ( proxy execution ?? ) |
| Date: | 1999-05-10 13:21:39 |
| Message-ID: | m10gq03-00080dC@mailbox.reptiles.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)reptiles(dot)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 ]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Bitmead | 1999-05-10 13:44:42 | Re: [GENERAL] virtual fields ( proxy execution ?? ) |
| Previous Message | paulmoody | 1999-05-10 12:50:31 | Re: [GENERAL] virtual fields ( proxy execution ?? ) |