Re: getting postgres to emulate mysql/sqlserver bit datatype
| От | Anton Melser |
|---|---|
| Тема | Re: getting postgres to emulate mysql/sqlserver bit datatype |
| Дата | |
| Msg-id | 92d3a4950702121316v5f43e1e3n1d59ac45d9e3e3bc@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: getting postgres to emulate mysql/sqlserver bit datatype (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: getting postgres to emulate mysql/sqlserver bit datatype
|
| Список | pgsql-general |
> I think actually what he needs is what Peter suggested upthread, namely
> to weaken the context-restriction on the int-to-bool cast.
Indeed... Peter's suggestion seems to have solved all my problems. So
even though it probably shows just how embarrassingly bad my sql is...
update pg_cast set castcontext = 'i'
where (castsource = (select oid from pg_type where typname = 'bool')
and casttarget = (select oid from pg_type where typname = 'int4'))
or (castsource = (select oid from pg_type where typname = 'int4')
and casttarget = (select oid from pg_type where typname = 'bool'))
For the archives.
Thanks to everyone.
Anton
ps. This is probably only for situations where it is absolutely
necessary... but I am now passing my nunit tests! :-)
В списке pgsql-general по дате отправления: