From: Rajesh Kumar Mallah. <mallah@trade-india.com>
To: Gabriel Dovalo Carril <dovalo@terra.es>
To: Lista SQL de postgres <pgsql-sql@postgresql.org>
Subject: Re: Functions with dynamic queries
Date: Thu, 23 May 2002 19:14:27 +0530
Message-ID: <200205231914.27923.mallah@trade-india.com> (raw)
In-Reply-To: <3CECC5C5.BDF77592@terra.es>
References: <3CECC5C5.BDF77592@terra.es>
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
,--
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.
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: mallah@trade-india.com, dovalo@terra.es
Subject: Re: Functions with dynamic queries
In-Reply-To: <200205231914.27923.mallah@trade-india.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