Displaying 1 result from an estimated 1 matches for "matrix_wet_color_value".
2009 Jun 04
2
RPostgreSQL segfault with LEFT JOIN
...atment of null values?
Any ideas?
Thanks!
Dylan
Here is the code that caused the error
----------------------------------------------------------------------------------------------------
# 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(...