From: Alessandro Busato <alessandro.busato@elettra.trieste.it>
To: pgsql-sql@postgresql.org
Subject: pgSQL, executing generic query
Date: Mon, 31 Oct 2005 17:43:19 +0000
Message-ID: <436657B7.80705@elettra.trieste.it> (raw)
Hi,
I should to write a function which has one text parameter ;
throught this parameter a query will be passed to the function;
in the function the query will be executed and the result put in the
record type;
the problem is:
how can I to get the columns value if the query is not defined a priori?
i.e. I can't use the contruct "record".fieldname
I've searched everywhere but nothing.
is it possible with pgSQL? have you any suggest?
Thanks,
Alessandro
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: alessandro.busato@elettra.trieste.it
Subject: Re: pgSQL, executing generic query
In-Reply-To: <436657B7.80705@elettra.trieste.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox