Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am trying to query the values of a series of columns NAME_# with the # matching the values of another column LEVEL and then populating another column with what I retrieve

share|improve this question
You would need to write a function which dynamically creates the NAME_# query after running the LEVEL query. The NAME_# query could then use the results saved from the LEVEL query. –  Micha Dec 1 '12 at 15:22
This sounds like a schema design issue to me. Maybe you need to check out hstore, XML or json columns, or even (ugh) EAV? –  Craig Ringer Dec 2 '12 at 8:48

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.