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

Поиск
Список
Период
Сортировка
От paulmoody
Тема Re: [GENERAL] virtual fields ( proxy execution ?? )
Дата
Msg-id 3736D617.99FD0E9C@onaustralia.com.au
обсуждение исходный текст
Ответ на virtual fields ( proxy execution ?? )  (paulmoody <paulmoody@onaustralia.com.au>)
Ответы Re: [GENERAL] virtual fields ( proxy execution ?? )  (jim@reptiles.org (Jim Mercer))
Список 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 по дате отправления:

Предыдущее
От: Herouth Maoz
Дата:
Сообщение: Re: [GENERAL] Restore from dump file: parse error
Следующее
От: jim@reptiles.org (Jim Mercer)
Дата:
Сообщение: Re: [GENERAL] virtual fields ( proxy execution ?? )