Postgres Pro
Downloads
Home   >   mailing lists

Execute a query passed by parameters to a function - Mailing list pgsql-general

From Yadira Lizama Mue
Subject Execute a query passed by parameters to a function
Date
Msg-id 193884470.266071257781994920.JavaMail.root@ucimail3.uci.cu
Whole thread Raw
Responses Re: Execute a query passed by parameters to a function  (Thom Brown <thombrown@gmail.com>)
List pgsql-general
Tree view 
Hi,
I have a function which receive a parameters as text. This text is a query. I want to execute this query, but I don't
knowhow. Can any one help me? 
Regards,
Yadira


CREATE OR REPLACE FUNCTION myfunction(text)
  RETURNS void AS
$BODY$
--I want execute the text I pass by parameters as a query.
$BODY$
 LANGUAGE 'sql' VOLATILE

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: I can't seem to put the right combination of magic into the pg_hba and pg_ident files.
Next
From: Alexandra Roy
Date:
Subject: Re: PostgreSQL 8.3.8 on AIX5.3 : compilation failed