Re: Functions with dynamic queries - Mailing list pgsql-sql

From Rajesh Kumar Mallah.
Subject Re: Functions with dynamic queries
Date
Msg-id 200205231914.27923.mallah@trade-india.com
Whole thread Raw
In response to Functions with dynamic queries  (Gabriel Dovalo Carril <dovalo@terra.es>)
List 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.




pgsql-sql by date:

Previous
From: "Rajesh Kumar Mallah."
Date:
Subject: Re:
Next
From: Bruno Wolff III
Date:
Subject: Re: