Received: from post.webmailer.de (natpost.webmailer.de [192.67.198.65]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g16HvVE08009 for ; Wed, 6 Feb 2002 12:57:32 -0500 (EST) (envelope-from barwick@gmx.net) Received: from there (pD9517264.dip.t-dialin.net [217.81.114.100]) by post.webmailer.de (8.9.3/8.8.7) with SMTP id SAA03035; Wed, 6 Feb 2002 18:57:35 +0100 (MET) Message-Id: <200202061757.SAA03035@post.webmailer.de> Content-Type: text/plain; charset="iso-8859-1" From: Ian Barwick To: Evil Azrael , pgsql-sql@postgresql.org Subject: Re: Query with Parameters Date: Wed, 6 Feb 2002 18:57:33 +0100 X-Mailer: KMail [version 1.3.1] References: <200202042320.g14NKiQ28800@usermail.freecity.de> <169124879927.20020206175323@evilazrael.de> In-Reply-To: <169124879927.20020206175323@evilazrael.de> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Archive-Number: 200202/71 X-Sequence-Number: 6501 On Wednesday 06 February 2002 17:53, 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? Nope, at least as far as VIEWs go. > Or > have i overseen something in the documentation or in the 1.8 million > pages about PgSQL which Google.com knows? See for example: http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=x7379%2ehtm hth Ian Barwick