From: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
---|---|
To: | Justin Graf <justin(at)magwerks(dot)com> |
Cc: | Peter Koczan <pjkoczan(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Domains, casts, and MS Access |
Date: | 2010-08-04 21:40:42 |
Message-ID: | AANLkTikXPkDmRYjk05-64pk-sTjc1w=nNGB+WjCm9nOr@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Wed, Aug 4, 2010 at 1:24 PM, Justin Graf <justin(at)magwerks(dot)com> wrote:
> My memory is fuzzy but there are some additional settings in Access that
> allows data type mapping...
My experience is that PostgreSQL Integer types work the best for
MS-Access bit datatype considering the fact that in Access -1 = true.
I know that there is a setting in the ODBC driver for true = -1 but it
doesn't work well. I also remember that filters didn't work on mapped
boolean columns.
For example:
2010-06-08 14:39:43 PDTERROR: invalid input syntax for type boolean:
"-1" at character 49
2010-06-08 14:39:43 PDTSTATEMENT:
BEGIN;
UPDATE "public"."structures"
SET "scoped"=E'-1'
WHERE "buildingfunction" = E'CRANE OPERATOR STATION'
AND "xmin" = 20497
-06-08 14:39:43 PDTLOG: duration: 0.000 ms statement: ROLLBACK
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma | 2010-08-04 21:52:50 | Re: Delete rules |
Previous Message | Frank Bax | 2010-08-04 21:33:48 | Re: What does PostgreSQL do when time goes backward? |