Displaying 1 result from an estimated 1 matches for "hz_number".
Did you mean:
nz_number
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", user=&quo...