> > Hi all, > > this is from the is there a way file. > Is there a way to get the name of the relation or relations in a query > from within the query? Like some kind of magic variable...? > for example : > "select *, from thistable" > where would be replaced by thistable. > > > Rhys > Peace & Love|Live Long & Prosper >
No as far as I know, but you can create a stored procedure and pass as parameter the table and then "create" your own query and execute it from within the stored procedure http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html EXECUTE 'UPDATE '|| some_magic_variable || ' SET ' || quote_ident(colname) || ' = ' || quote_literal(newvalue) || ' WHERE key = ' || quote_literal(keyvalue); I haven't tried it thought. _________________________________________________________________ Tenemos lo que búscas…JUEGOS. http://club.prodigymsn.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
