> From: "Kim Hansen" <[EMAIL PROTECTED]> > To: pgsql-bugs@postgresql.org > Date: Mon, 24 Jan 2005 00:41:10 GMT > Subject: BUG #1437: converting column from text to int4 requires USING > > The following bug has been logged online: > > Bug reference: 1437 > Logged by: Kim Hansen > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.0 > Operating system: Windows > Description: converting column from text to int4 requires USING > Details:
I have just found out that this isn't a bug. I just didn't know that there was a difference between 'assignment cast' and 'implicit cast'. I think that the error message from line 3 is misleading as line 4 casts column a into int4. Perhaps a HINT: could be added that an explicit typecast might be needed. Regards, -- Kim Hansen Vadgårdsvej 3, 2.tv 2860 Søborg Tlf: 39 56 24 37 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
