From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: Yudha Setiawan <inas_husband@BonBon.net>
To: pgsql-sql@postgresql.org
Subject: Re: Language SQL, But Need Return PlPgSql
Date: Wed, 9 Apr 2003 16:53:36 +0530
Message-ID: <200304091653.36745.mallah@trade-india.com> (raw)
In-Reply-To: <018101c2fdb8$6e46d1e0$ea00a8c0@yudha>
References: <018101c2fdb8$6e46d1e0$ea00a8c0@yudha>
Is your problem finally solved?
regds
mallah.
On Tuesday 08 Apr 2003 3:22 pm, Yudha Setiawan wrote:
> Dear Expert;
> Gimme your hand please,
> I've been using function with "Language SQL" and combined with
> "type" for the simply-one. Like this;
> -------------------------------------
> create type simply_1 as(
> fc_name char(20),
> fn_codedept integer,
> fc_descdept char(30) );
>
> Create function F_Simple(integer) returns setof d_4developer.ty_rep_coba as
> ' select a.fc_name, a.fn_codedept, b.fc_descdept
> from Emplo_Corp a, Depart b
> where a.fn_codedept = b.fn_codedept and
> a.fn_codedept = $1;
> ' language SQL;
> --------------------------------------
>
> That's running pretty good. But now i have more complicated condition.
> There are hundreds combination of reports must be handled by me and
> most of all have the same result. If i still using style of "Language
> SQL", that's means I will have to make function as much as my report.
> I Tried Using style "Language PlPgSql" but I got a Fully Confused
> about what a kind of RETURN i will use ??
> -------------------------------------------------
> Create or replace function MultiRpt(integer,char(1))
> setof d_4developer.ty_rep_coba as
> 'begin
> -- View Corporate's Employee
> If $2 = ''C'' Then
> select a.fc_name, a.fn_codedept, b.fc_descdept
> from Emplo_Corp a, depart b
> where a.fn_codedept = b.fn_codedept and
> a.fn_codedept = $1;
> End If;
>
> -- View Branch'A' Employee
> If $2 = ''A'' Then
> select a.fc_name, a.fn_codedept, b.fc_descdept
> from Emplo_BRANCH_A a, depart b
> where a.fn_codedept = b.fn_codedept and
> a.fn_codedept = $1;
> End If;
>
> -- View Branch'B' Employee
> If $2 = ''B'' Then
> select a.fc_name, a.fn_codedept, b.fc_descdept
> from Emplo_BRANCH_B a, depart b
> where a.fn_codedept = b.fn_codedept and
> a.fn_codedept = $1;
> End If;'
> Return (-- ?? --)
> end;' language PlPgSql;
> -------------------------------------------------
>
> Some advice will be helpfull. Thank's
> GOD Bless You All and Bravo Postgres !!
>
>
>
> Yudha Setiawan.
> VoIP
> No. : 628899911223344
--
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, inas_husband@BonBon.net
Subject: Re: Language SQL, But Need Return PlPgSql
In-Reply-To: <200304091653.36745.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