On Wed, Oct 12, 2011 at 6:46 AM, J.V. <jvsrvcs@xxxxxxxxx> wrote: > I want to create a variable that is an array or list of key/value pairs. > > The key would be a table name and the value would be a sql statement or a > value or list of values for which I could extract to create a sql statement > and execute. > > I have tried experimenting with various arrays, but there is no clear > example or documentation. The key and the value would be text. > > I want to iterate over the entire array (or list), so would need an example > on that or some pointers there, if there is help. > Which version of PostgreSQl are you running? It's a little easier on 8.4 and higher (unnest comes in handy here), but prior to 1.4 you can loop from array_lower to array_upper..... Best Wishes, Chris Travers -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
