Re: dynamic table names

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.