From: Jeff Eckermann <jeff_eckermann@yahoo.com>
To: Evil Azrael <evilazrael@evilazrael.de>
To: pgsql-sql@postgresql.org
Subject: Re: Query with Parameters
Date: Wed, 6 Feb 2002 11:24:11 -0800 (PST)
Message-ID: <20020206192411.12181.qmail@web20805.mail.yahoo.com> (raw)
In-Reply-To: <169124879927.20020206175323@evilazrael.de>
One possible way, from the psql command line:
\set field some_field
\set table some_table
\i myscript
where "myscript" contains:
select :field from :table;
You can do this from a script by calling psql with the
-f and -v options. Check the psql man page (or the
docs) for more information.
Alternatively, you could try a function: the field and
table names can be assigned dynamically using EXECUTE.
You could then populate a temporary table with the
results, and fetch those with a separate SELECT
statement (this gets around the inability to return
resultsets directly from the function).
--- Evil Azrael <evilazrael@evilazrael.de> wrote:
> Hello!
>
> I hope this question was not asked before.
>
> What i need is SELECT with parameters. Afaik Views
> don´t take
> parameters and functions can´t return multiple
> tuples. Am i right? Or
> have i overseen something in the documentation or in
> the 1.8 million
> pages about PgSQL which Google.com knows?
>
> My main problem is that i have a complex query in
> which very often the
> same tables and fields are being used. A simple
> SQL-function would be
> very handy, but how do i return multiple records at
> the same time?
>
> as a simple example, is a function like this
> possible?
> SELECT funktion('field','table');
> where funktion is implemented like this :
> SELECT $1 FROM $2;
>
>
> Thanks for any answer in advance
>
> Christoph Nelles
> evilazrael@evilazrael.de
>
>
> --
> Mit freundlichen Grüssen
> Evil Azrael
> mailto:evilazrael@evilazrael.de
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to majordomo@postgresql.org
> so that your
> message can get through to the mailing list cleanly
__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
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: jeff_eckermann@yahoo.com, evilazrael@evilazrael.de
Subject: Re: Query with Parameters
In-Reply-To: <20020206192411.12181.qmail@web20805.mail.yahoo.com>
* 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