Received: from mailout05.sul.t-online.com (mailout05.sul.t-online.com [194.25.134.82]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g16Gp9E86898 for ; Wed, 6 Feb 2002 11:51:09 -0500 (EST) (envelope-from evilazrael@evilazrael.de) Received: from fwd11.sul.t-online.de by mailout05.sul.t-online.com with smtp id 16YVHt-0003ko-06; Wed, 06 Feb 2002 17:51:13 +0100 Received: from router.azrael.de (520093347591-0001@[217.228.9.222]) by fmrl11.sul.t-online.com with esmtp id 16YVHi-15M9kuC; Wed, 6 Feb 2002 17:51:02 +0100 Received: from azrael.azrael.de (azrael.azrael.de [192.168.202.18]) by router.azrael.de (8.11.6/8.11.4) with ESMTP id g16Gp1v09152 for ; Wed, 6 Feb 2002 17:51:01 +0100 Date: Wed, 6 Feb 2002 17:53:23 +0100 From: Evil Azrael X-Mailer: The Bat! (v1.52f) Reply-To: Evil Azrael X-Priority: 3 (Normal) Message-ID: <169124879927.20020206175323@evilazrael.de> To: pgsql-sql@postgresql.org Subject: Query with Parameters In-Reply-To: <200202042320.g14NKiQ28800@usermail.freecity.de> References: <200202042320.g14NKiQ28800@usermail.freecity.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Sender: 520093347591-0001@t-dialin.net X-Archive-Number: 200202/69 X-Sequence-Number: 6499 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