Re: Problemas with update sentence in postgres from jdbc

it seems you are trying to insert an int value in an array column. check your schema

---- Original Message ----
Hi:<br><br>I try this ...<br><br>String sql =&quot;UPDATE crupier &quot;+<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;SET&nbsp; c_estado=&#39;&quot;+cestado+&quot;&#39; WHERE &quot;+<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot; c_rut=&#39;&quot;+crut+&quot;&#39; &quot;;<br>
<br>and send me the next exception Error:<br><br>04-04-2008 07:00:03 PM Persistencia.Mesa ActualizarTupla<br>GRAVE: null<br>org.postgresql.util.PSQLException: ERROR: el valor de array debe comenzar con «{» o información de dimensión<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org...