RPostgreSQL - Nested selects

Asked May 18 '17 at 14:59

Active May 18 '17 at 14:59

Viewed 92 times

I am trying to:

dbGetQuery(conn, "SELECT * FROM test WHERE id in (select fid from test2)")

However, I get the error:

 RS-DBI driver: (could not Retrieve the result : ERROR:  column "fid" does not exist

Is nested selects not supported by RPostgreSQL?

asked May 18 '17 at 14:59

Tino K Stigsen

Yes, no problems in PgAdmin – Tino K Stigsen May 18 '17 at 15:21
Okay, the problem was that "fid" was with capital letters in the database. So apparently they are converted to small letters when running the dbGetQuery command. – Tino K Stigsen May 19 '17 at 20:43

0 Answers0