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

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(at)foo(dot)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.

paulmoody wrote:
>
> Hi,
> My first post to this list ... pls point me to correct list if
> wrong. Now my question ...
> Can I reference a field in a record where the data contained in the
> field is a value returned or passed to an arbitrary executable. For
> example say the arbitrary executable was a mail program then writing to
> the field would send a message and reading from the field would retrieve
> a message. However for all intents and purposes there would be no
> difference perceived by the query orginator than if the message was
> merely stored or retrieved from that field. ( ie is there a 'CGI' type
> interface for postgresql like for webservers ? ).
> TIA and regards.

--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris(dot)bitmead(at)bigfoot(dot)com