The following bug has been logged online: Bug reference: 3951 Logged by: vha Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: Windows XP SP2 Description: SELECT ... WHERE Param = ? does not work if Param is of type bytea Details:
I have a table with one of the columns of type BYTEA containing GUIDs (16 bytes of data). The data of the column is specified using SQLBindParameter(hstmt, nCol, SQL_PARAM_INPUT, SQL_C_BINARY, SQL_BINARY, 16, 0, theGUID, 16, &ptr). This works fine to insert the data using "INSERT ... VALUES ?", but retrieving the data using "SELECT ... WHERE Param = ?" doesn't work: nothing is returned. Am I doing something wrong or is this a bug? BTW. This code works without any problem on MS SQL 2000, MS SQL 2005, Oracle and MySQL. vha ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly