Ok. Now I get it. Guess I worked on this too long yesterday. Thanks for the
help.
On Friday 26 March 2004 04:46 pm, Terry Lee Tucker saith:
> 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
--
Work: 1-336-372-6812
Cell: 1-336-363-4719
email: terry@esc1.com