Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 8B07F476117 for ; Thu, 23 May 2002 10:11:39 -0400 (EDT) Received: from mail-relay.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 3850347622C for ; Thu, 23 May 2002 09:44:37 -0400 (EDT) Received: (qmail 18034 invoked from network); 23 May 2002 13:38:53 -0000 Received: from system29.trade-india-local.com (HELO server) (192.168.0.29) by ptil-236-129-del.primus-india.net with SMTP; 23 May 2002 13:38:53 -0000 Content-Type: text/plain; charset="iso-8859-1" From: "Rajesh Kumar Mallah." Organization: Infocom Network Limited. To: Gabriel Dovalo Carril , Lista SQL de postgres Subject: Re: Functions with dynamic queries Date: Thu, 23 May 2002 19:14:27 +0530 X-Mailer: KMail [version 1.4] References: <3CECC5C5.BDF77592@terra.es> In-Reply-To: <3CECC5C5.BDF77592@terra.es> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200205231914.27923.mallah@trade-india.com> X-Archive-Number: 200205/257 X-Sequence-Number: 7892 I guess the examples on standard docs explain it. dont they? > > A very simple case would be: > > Create table people ( > nif char(12), > name varchar(40), > primary (nif) > ); > > And now to create a function to return "name" value giving > "nif" values as a parameter. you may not need a function at all if your case is that simple . you can use subselects and || operators to do many complicated things.. can we know a bit more abt. your specific problem regds ,--=20 Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.