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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
