Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.