> > I would like to be able to execute SQL queries by a direct call into
> > Postgres, without going through either (1) the language call handler
> > or (2) a 'wire' protocol.
>
> What would you consider to be "directly"? What advantage would you hope
to
> gain from a different API?
The aim is to execute Andl code at the top level, not inside SQL. So instead
of:
>>>SELECT * FROM AndlFunc(args);
I need
>>>AndlFunc(args)
> FWIW, it seems unlikely to me that we would consider anything much lower-
> level than SPI to be an officially-supported query interface.
> You could no doubt run a query by calling assorted backend functions
directly
> from a PL implementation, but it would be mostly on your own head whether
> that worked and kept working across releases.
No, SPI is quite low enough level for me. I really don't want or need to go
lower than that.
So the question is: Can a C program link to the Postgres DLL and call SPI
directly, rather than through a language function?
Is there a way to launch a Thrift server or a Web server and call SPI
directly?
Regards
David M Bennett FACS
Andl - A New Database Language - andl.org