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

From paulmoody
Subject Re: [GENERAL] virtual fields ( proxy execution ?? )
Date
Msg-id 3736D617.99FD0E9C@onaustralia.com.au
Whole thread Raw
In response to virtual fields ( proxy execution ?? )  (paulmoody <paulmoody@onaustralia.com.au>)
Responses Re: [GENERAL] virtual fields ( proxy execution ?? )  (jim@reptiles.org (Jim Mercer))
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.

Chris Bitmead wrote:

> I'm a bit vague on what you mean. Are you saying you want to be able to
> say to postgres...
>
> INSERT INTO message(to,subject,body) VALUES ('fred@foo.com', 'Hello',
> 'How\'s it going');
>
> and instead of storing a message into postgres, it will send a mail
> message to fred?
>
> Then you want to say...
> SELECT to, subject, body FROM messages;
>
> And have a list of mail messages be returned, not from postgres tables,
> but from your UNIX mailbox?
>
> Just want to be clear on what you are asking.
>


pgsql-general by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] Restore from dump file: parse error
Next
From: jim@reptiles.org (Jim Mercer)
Date:
Subject: Re: [GENERAL] virtual fields ( proxy execution ?? )