Hey sql@,<br /><br /><div class="gmail_quote">---------- Forwarded message ----------<br />From: <b
class="gmail_sendername">DmitriyIgrishin</b> <span dir="ltr"><<a
href="mailto:dmitigr@gmail.com">dmitigr@gmail.com</a>></span><br/> Date: 2010/12/9<br />Subject: Extended query
protocoland exact types matches.<br />To: <a
href="mailto:pgsql-general@postgresql.org">pgsql-general@postgresql.org</a><br/><br /><br />Hey general@,<br /><br />To
beassured and just for calmness.<br /><br />Problem:<br /><br />1. CREATE TABLE test_tab (id integer, dat
varchar(64));<br/><br />2. INSERT INTO test_tab VALUES($1, $2) via PQexecParams,<br /> where paramTypes[0] == OID of
bigint,<br/> paramTypes[1] == OID of text.<br /><br />Questions:<br /><br />Whether this case falls to<br
/><ahref="http://www.postgresql.org/docs/9.0/static/typeconv-query.html"
target="_blank">http://www.postgresql.org/docs/9.0/static/typeconv-query.html</a>?<br /><br />Is such cases safe or it
isrecommended (best) to specify a<br />OIDs which are exact matches ?<br /><br />PS.<br /><br />I know, that queries
likeSELECT $1 does not work without<br />specifying OID or without rewriting it to e.g. SELECT $1::text.<br /><br
/>Thanks.<br/><br />-- <br /><font color="#888888">// Dmitriy.<br /><br /><br /></font></div><br /><br clear="all"
/><br/>-- <br />// Dmitriy.<br /><br /><br />
