skip to Main Content

Loop tables in postgreSQL

I need to create a Materialized view to loop all worklist tables from pg_tables. First I create a query and after tried to create a for loop. This my first code without the for loop. SELECT count(visit_num) AS total_claim_count, count(user_id)…

VIEW QUESTION

web scraping with loop – Html

I'm trying to download zip codes that are in different pages. I started with a list of nodes for each municipality inside Mexico City. url<-"https://www.codigopostal.lat/mexico/Ciudad-de-Mexico/" resource<-GET(url) parse<-htmlParse(resource) links<-as.character(xpathSApply(parse,path="//a",xmlGetAttr,"href")) print(links) And then I'm trying to create a loop that grabs each…

VIEW QUESTION
Back To Top
Search