On 4/9/06, Chethana, Rao (IE10) <
Chethana.Rao@honeywell.com> wrote:
>
>
>
>
> Hello!
>
>
>
> Kindly go through the following ,
>
>
>
>
>
> I wanted to know whether, the command line arguments(function arguments) ------ $1 $2 $3 -- can be used as in the following , like, ----
>
>
>
>
>
> CREATE TYPE TT AS(something,something,…………………………………………………………etc………………);
>
> CREATE OR REPLACE FUNCTION f1(varchar,varchar,varchar,varchar) RETURNS …………………..(something)………….
>
the overall idea expressed is doable.
following are comments
1. you have to put RETURNS setof TT (if you plan to return TT) since you used RETURN NEXT
2. you have to use SELECT INTO rec in the function where rec is rowtype TT
hope it helps
------- non technical comments ------------------------------------------------------
3. its not a performance question , it shud have been marked more appropriately to pgsql-sql i think.
4. its not a good etiquette to address email to someone and mark Cc to a list.
kind regds
mallah.
>
>
> BEGIN
>
> SELECT a1,a2,a3,a4,a5,a6
>
> FROM (SELECT * FROM T1, T2……WHERE …………etc… Flag = 0 $1 $2 $3 $4)
>
> ORDER BY ……………………
>
> ………………………….
>
> RETURN NEXT ………;
>
> END LOOP;
>
> RETURN;
>
> END;
>
> ' LANGUAGE 'plpgsql';
>
>
>
> NOTE : The values for $1 $2 $3 $4 will be passed when the function is invoked(called) from the command prompt.
>
>
>
> I tried implementing the above, but this type of usage is not supported , how should use it?
>
>
>
> I am converting from (sprintf, "SELECT query stmts (which uses %s %s %s %s …… ) to functions.
>
>
>
>
>
> Any help will be deeply appreciated. Thank you.
>
>
>
>
>
> Kind regards,
>
> Chethana.
>
>
>
>
>
>