| From: | Tk421 <vrobador(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Problem inserting data |
| Date: | 2008-06-20 12:20:18 |
| Message-ID: | 485BA082.8060605@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Preston | 2008-06-20 13:05:48 | Cross Tab Functions |
| Previous Message | Peter Kovacs | 2008-06-20 07:37:49 | Re: "TZ"/"tz" not supported |