Problem inserting data
От | Tk421 |
---|---|
Тема | Problem inserting data |
Дата | |
Msg-id | 485BA082.8060605@gmail.com обсуждение исходный текст |
Ответы |
Re: Problem inserting data
|
Список | 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
В списке pgsql-sql по дате отправления: