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

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: Raw Message | Whole Thread | 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 ]

In response to

Browse pgsql-general by date

  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 ?? )