Displaying 2 results from an estimated 2 matches for "query_duj_kal".
2009 Sep 13
2
zoo plot: yearly marks on X-Axis
...s,
> Christian
Hello,
I'm actually struggling with the similar problem. I applied Your script
into mine like this:
-
library(Rdbi)
library(RdbiPgSQL)
conn <- dbConnect(PgSQL(), host="localhost", dbname="BVS",
user="postgres", password = "******")
query_duj_kal <- dbSendQuery(conn, "select zdroj as well, cas as date,
fe2, fe3, mn, nh4, no2, no3, o2, teplota as temperature from analystats
where zdroj like 'Dunaj Kalinkovo' order by date")
watchem_duj_kal <- dbGetResult(query_duj_kal)
date <- (watchem_duj_kal$date)
date_p <- s...
2009 Sep 11
1
format (?) problems with data imported from postgres
...read some data from a PostgreSQL database by a following script:
library(Rdbi)
library(RdbiPgSQL)
# conn becomes an object which contains the DB connection:
conn <- dbConnect(PgSQL(), host="localhost", dbname="BVS",
user="postgres", password = "*******")
query_duj_kal <- dbSendQuery(conn, "select zdroj as well, cas as date,
fe2, fe3, mn, nh4, no2, no3, o2, teplota as temperature from analystats
where zdroj like 'Dunaj Kalinkovo'")
watchem_duj_kal <- dbGetResult(query_duj_kal)
My intention with the data is to create a time series by a fol...