On Fri, 12 Jul 2002, [EMAIL PROTECTED] wrote: > Hi > We’re two doctoring students and we have a little problem to resolve. > We’re using Grass5pre3 and PostgreSQL 7.2 (Linux)to map vehicular > pollution of our city. We have a map of the streets and we have to > assign 24 values (+ the label) to each street. > What would be a smart way to solve this problem using Postgres? > Thanx a lot for your help, Alberto & Massimo. >
I'd use contrib/intarray module, which was developed exactly for such kind of problems (in our case we have messages assigned to several sections) Regards, Oleg > > > Salve. > Siamo due studenti laureandi e avremmo un problema da risolvere. > Stiamo utilizzando Grass5pre3 e PostgreSQL 7.2 (Linux)per realizzare > una mappatura dell’inquinamento veicolare nella nostra città. > Abbiamo una mappa delle vie e dobbiamo assegnare ad ogni via 24 valori > (più l’etichetta). > Qual e’ il modo più furbo e veloce per farlo, utilizzando Postgres? > Grazie Mille per l’aiuto, Alberto & Massimo. > > > > > > > -- > Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f > > Sponsor: > Conto Arancio. Zero spese, stessa banca, più interessi. > Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=657&d=12-7 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html