On Tue, 2004-10-19 at 15:21, Hicham G. Elmongui wrote: > I tried creating the function (from sec 19.3.1). But it gives me the > following error: "ERROR: type tablename does not exist". > Any ideas of what i might be doing wrong? > > CREATE FUNCTION use_many_fields(tablename) RETURNS TEXT AS '
You are passing a composite type for a row from the table called "tablename"; such a table does not exist. Use the name of a table that actually exists (and has the fields named in the RETURN statement). > DECLARE > in_t ALIAS FOR $1; > BEGIN > RETURN in_t.f1 || in_t.f3 || in_t.f5 || in_t.f7; > END; > ' LANGUAGE 'plpgsql'; -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== "For the LORD God is a sun and shield; the LORD will give grace and glory; no good thing will he withhold from them that walk uprightly." Psalms 84:11 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
