The following bug has been logged online: Bug reference: 1619 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.1 Operating system: Suse Linux 9.1 (x86) Description: ECPG allows definition of binary cursors but can't handle the result Details:
I'm not certain this is a "bug", but seems a un-documented restriction of ECPG. one can use a binary cursor definition in a ECPG program, but there is no (or no documented) way of fetching the data into host variables, as this allways assumes a text representation. thus for example, when fetching an integer type field from a binary cursor into a 'int', the applied conversion implicitly assumes an empty string if the first byte retrieved is '\0' and will assign a zero value to the 'int', even if the binary representation received from the server has a non zero interpretation (.e.g. like receiving the four bytes 00,FF,FF and FF). maybe it would be a good idea to explicitly mention this in the manual as a restriction and/or to generate an error when ecpg encounters a binary cursor? ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
