[GENERAL] Delete with a multi-column join?

Howdy! I apologize in advance for the ugly query I'm about to throw your way I need to delete some data from a table based on a multi-column join. Is there a better way to write this? delete from tbldata where unitID || '_' || variableID || '_' || cycleID in (select unitID || '_' || variab

[GENERAL] "Invalid message format" error from JDBC driver

Hello, all. I have a query that runs perfectly when I run it from pgAdmin3, but bombs when I run it from ColdFusion using the JDBC driver. I'm using postgres 7.4. The query uses dblink(), which I assume is the source of the problem. Can anyone provide me with any insight about why this would fa