Received: from web20805.mail.yahoo.com (web20805.mail.yahoo.com [216.136.226.194]) by postgresql.org (8.11.3/8.11.4) with SMTP id g16JOBE26601 for ; Wed, 6 Feb 2002 14:24:12 -0500 (EST) (envelope-from jeff_eckermann@yahoo.com) Message-ID: <20020206192411.12181.qmail@web20805.mail.yahoo.com> Received: from [68.11.77.27] by web20805.mail.yahoo.com via HTTP; Wed, 06 Feb 2002 11:24:11 PST Date: Wed, 6 Feb 2002 11:24:11 -0800 (PST) From: Jeff Eckermann Subject: Re: Query with Parameters To: Evil Azrael , pgsql-sql@postgresql.org In-Reply-To: <169124879927.20020206175323@evilazrael.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200202/72 X-Sequence-Number: 6502 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 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