Displaying 2 results from an estimated 2 matches for "pedon_id".
Did you mean:
exon_id
2009 Jun 04
2
RPostgreSQL segfault with LEFT JOIN
...---------------------------------------------------------------------------
# libs
library(RPostgreSQL)
## query DB
q <- "
SELECT deb_lab_data.*
-- matrix_wet_color_hue as hue, matrix_wet_color_value as value,
matrix_wet_color_chroma as chroma
FROM deb_lab_data
-- LEFT JOIN horizon USING (pedon_id, hz_number)
WHERE deb_lab_data.pedon_id ~~ '%SJER%'
ORDER BY deb_lab_data.pedon_id, deb_lab_data.top ASC "
# create an PostgreSQL instance and create one connection.
drv <- dbDriver("PostgreSQL")
conn <- dbConnect(drv, host="localhost", dbname="XXX"...
2009 Jan 13
0
crash on multiple queries to postgresql db [solved]
...ut possible bad data:
>> query <- dbSendQuery(conn, query_text)
>>
>> # fetch data according to query:
>> res <- dbGetResult(query)
>> # convert characters to factors
>> res <- transform(res, probe_id = factor(probe_id))
>> res <- transform(res, pedon_id = factor(pedon_id))
>>
>> # generate a new date-time object in the dataframe
>> res$date <- as.POSIXct(strptime(res$date_time, format="%a %b %e %H:%M:%S
>> %Y"))
>>
>> # cleanup
>> dbDisconnect(conn)
>>
>> # doesn't completely f...