On 3/12/2009 12:35 AM, Tom Lane wrote:
"Kurt wagner"<kurt.wagnerext...@leoni.com> writes:
During migration from Informix to Postgres I came across following issue:
create temp table temp1 as
SELECT firmnr,
werknr,
'I' as invper,
invnum
from .... ;
You really ought to cast the 'I' to some specific type.
It's usually neatest to do this by just explicitly identifying the
intended type in the first place, eg:
SELECT firmnr,
werknr,
TEXT 'I' as invper,
invnum
from .... ;
... which, IIRC, is the standard way to do it. I don't have a copy to
check against to be sure.
Personally, I like the fact that Pg errs on the side of caution here
rather than guessing what you want.
--
Craig Ringer
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
