Re: Functions with dynamic queries

From: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>
To: Gabriel Dovalo Carril <dovalo(at)terra(dot)es>, Lista SQL de postgres <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Functions with dynamic queries
Date: 2002-05-23 13:44:27
Message-ID: 200205231914.27923.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Nigel J. Andrews 2002-05-23 14:09:53 Re: MacOS X Shared Buffers (SHMMAX)?
Previous Message Rajesh Kumar Mallah. 2002-05-23 13:41:03 Re: