John Smith-54 wrote > any help? Sorry. Its hard enough teaching people via e-mail let alone teaching them on an unsupported version of PostgreSQL that has reduced functionality with respect to function writing compared to the more recent versions. You are going to need to some kind of "FOR" loop to iterate over each table you want to query and then use "EXECUTE" to actually perform the query using the syntax you referred to earlier. The more complete the examples of your work-in-progress you post the more help you are likely to get. Basically read the documentation and try things and if you get stumped post a specific question about what is stumping you (with as much detail as possible; but take time to organize and comment it) to get past the block. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/dynamic-table-names-tp5764134p5764161.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
