From: | Adrian Klaver <aklaver(at)comcast(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Cc: | Tk421 <vrobador(at)gmail(dot)com> |
Subject: | Re: Problem inserting data |
Date: | 2008-06-20 14:40:46 |
Message-ID: | 200806200740.46335.aklaver@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Friday 20 June 2008 5:20 am, Tk421 wrote:
> 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
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:
http://www.postgresql.org/docs/8.3/interactive/catalog-pg-cast.html
--
Adrian Klaver
aklaver(at)comcast(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-06-20 14:57:26 | Re: Problem inserting data |
Previous Message | Tom Lane | 2008-06-20 14:02:14 | Re: "TZ"/"tz" not supported |