Re: pls reply ASAP

On 4/9/06, Chethana, Rao (IE10) <Chethana(dot)Rao(at)honeywell(dot)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.
>
>
>
>
>
>