Re: [GENERAL] implicit cast works for insert, not for select

2015-01-22 Thread robertlazarski .
On Thu, Jan 22, 2015 at 12:25 PM, Tom Lane wrote: > You realize of course that you've set that to be an assignment cast, > not an implicit cast as the title of your message suggests. So this > only changes the behavior for assignment contexts, ie INSERT/UPDATE > target values. > Oops, my intent

Re: [GENERAL] implicit cast works for insert, not for select

2015-01-22 Thread Tom Lane
"robertlazarski ." writes: > The biggest problem has been the tiny int boolean that SQL Server > uses, which I can get to work for postgres inserts by: > atdev=# update pg_cast set castcontext = 'a' where castsource = > 'int'::regtype and casttarget = 'bool'::regtype; You realize of course that y

Re: [GENERAL] implicit cast works for insert, not for select

2015-01-22 Thread Adrian Klaver
On 01/22/2015 02:31 AM, robertlazarski . wrote: I am migrating a DB from SQL Server to Postgres 9.2.7 on Centos 7, via regex converting the SQL Server DDL to a Postgres DDL. Both DB's need to be supported in the near term. The biggest problem has been the tiny int boolean that SQL Server uses, w