>>From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Nick Raj >>Sent: Saturday, June 04, 2011 10:04 AM >>To: pgsql-general@postgresql.org >>Subject: [GENERAL] Pl/pgsql function >> >>Second thing, >>Suppose i defined a function test as >> >>select test('geom',the_geom,time) from tablename >>..... >>Inside body, >>How can i get the tablename inside the body (because i haven't pass table name to function) >>...... >>end
Not possible; a function only has access to the specific things you provide it. If you explain why you want the "tablename" maybe alternatives can be suggested. The only time you get access to the table name is when you are executing the function in the context of a trigger. David J. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
