Re: Problem inserting data - Mailing list pgsql-sql

From Tk421
Subject Re: Problem inserting data
Date
Msg-id 485BD2F2.2040204@gmail.com
Whole thread Raw
In response to Re: Problem inserting data  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-sql
Adrian Klaver escribió: <blockquote cite="mid:200806200740.46335.aklaver@comcast.net" type="cite"><pre wrap="">On
Friday20 June 2008 5:20 am, Tk421 wrote: </pre><blockquote type="cite"><pre wrap="">   Hello everybody.
 
   I''ve just converted an access database to postgres. The conversion
was ok, but when i'm trying to insert data on some tables with boolean
types from a Visual Basic application i receive an error. A sample:
   table example, with firs field of integer, second of type text and
third of type boolean
   the query: INSERT INTO EXAMPLE VALUES (1, 'text', 0)
   When i used access this worked fine, in boolean types 0 is false and
1 is true, but in postgres (8.1 and 8.3 version) i receive the next error:
   column "premarco" is of type boolean but expression is of type integer
   My question is, can i force postgres to accept integer values as
boolean without changin query to INSERT INTO EXAMPLE VALUES (1, 'text',
0::boolean). This is a problem because if I have to do this i will have
to test about one hundred queryes
   Thank you very much   </pre></blockquote><pre wrap="">
Two options:
1) Change the column in Postgres to an integer type.
2) Change the assignment in pg_cast from explicit  to implied for the 
int4,bool cast. See for more details:
<a class="moz-txt-link-freetext"
href="http://www.postgresql.org/docs/8.3/interactive/catalog-pg-cast.html">http://www.postgresql.org/docs/8.3/interactive/catalog-pg-cast.html</a>
</pre></blockquote>    Thank you very much. I've choosen the second option, using this query:<br /><br />        update
pg_castset castcontext='i' where castsource=23 and casttarget=16<br /><br /><br /> 

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem inserting data
Next
From: "Scott Marlowe"
Date:
Subject: Re: "TZ"/"tz" not supported