> > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
