---------- Forwarded message ---------- From: Dmitriy Igrishin <[email protected]> Date: 2010/12/10 Subject: Fwd: Extended query protocol and exact types matches. To: postgres list <[email protected]>
Hey sql@, ---------- Forwarded message ---------- From: Dmitriy Igrishin <[email protected]> Date: 2010/12/9 Subject: Extended query protocol and exact types matches. To: [email protected] Hey general@, To be assured and just for calmness. Problem: 1. CREATE TABLE test_tab (id integer, dat varchar(64)); 2. INSERT INTO test_tab VALUES($1, $2) via PQexecParams, where paramTypes[0] == OID of bigint, paramTypes[1] == OID of text. Questions: Whether this case falls to http://www.postgresql.org/docs/9.0/static/typeconv-query.html ? Is such cases safe or it is recommended (best) to specify a OIDs which are exact matches ? PS. I know, that queries like SELECT $1 does not work without specifying OID or without rewriting it to e.g. SELECT $1::text. Thanks. -- // Dmitriy. -- // Dmitriy. -- // Dmitriy.
