Hello,
code for genereting xml:
CREATE OR REPLACE FUNCTION ext.xml(varchar) RETURNS text AS $$
use DBI; use XML::Generator::DBI; use XML::Handler::YAWriter;
my $rv = spi_exec_query("SELECT current_setting('client_encoding'), " .
"current_database()", 1);
my $e
On Wed, Feb 09, 2005 at 11:29:21AM -0700, Roy Souther wrote:
> I need to be able to run a program when some data is requested from the
> database. Some query will do a SELECT on a known table and I need to have
> some event trigger that makes a call to generate a small XML file and then
> post
On Wednesday February 9 2005 11:29, Roy Souther wrote:
> I cannot find any information about wether PostgreSQL has
> EXTPROC or not. Can someone tell me if it dose or if there is
> a better way to do this.
Not sure what version you're using, but sounds like a job for
perl (plperl) + a select rule
I cannot find any information about wether PostgreSQL has EXTPROC or not. Can
someone tell me if it dose or if there is a better way to do this.
I need to be able to run a program when some data is requested from the
database. Some query will do a SELECT on a known table and I need to have
some
