Re: Passing a row - Mailing list pgsql-general

From Terry Lee Tucker
Subject Re: Passing a row
Date
Msg-id 200403261646.58881.terry@esc1.com
Whole thread Raw
In response to Re: Passing a row  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Passing a row
List pgsql-general
Thanks for your response. I looked the posts you reference, but, to be quite
frank, I didn't understand. I am confused regarding the sample code in the
documentation I am looking at. Here it is:

CREATE FUNCTION use_many_fields(tablename) RETURNS TEXT AS '
DECLARE
    in_t ALIAS FOR $1;
BEGIN
    RETURN in_t.f1 || in_t.f3 || in_t.f5 || in_t.f7;
END;
' LANGUAGE 'plpgsql';

If this code is workable code, I would love to see an example of the code that
would call such a function so I can determine how to pass the parameter. I
think I did a poor job of expressing my ignorance ;o)

Thanks...

On Friday 26 March 2004 10:59 am, Tom Lane saith:
> Terry Lee Tucker <terry@esc1.com> writes:
> > Can anybody show me the error of my ways?
>
> Seems like I just answered this yesterday ... ah, here we go:
> http://archives.postgresql.org/pgsql-general/2004-03/msg00862.php
>
> I don't recall if 7.3 has all the functionality of 7.4 in this regard.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

--
Quote: 53
"A soul can never attain the knowledge of God unless God Himself in His
 condescension takes hold of it and raises it up to Himself. For the
 human intellect lacks the power to ascend and to participate in divine
 illumination, unless God Himself draws it up -- in so far as this is
 possible for the human intellect -- and illumines it with rays of divine
 light."

 --The Philokalia

 Work: 1-336-372-6812
 Cell: 1-336-363-4719
email: terry@esc1.com

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: 7.4.2 on Solaris 9 - Error
Next
From: Bruno Wolff III
Date:
Subject: Re: Physical Database Configuration