|
|
 | | From: | Kim Hansen | | Subject: | Re: BUG #1437: converting column from text to int4 requires USING | | Date: | Mon, 24 Jan 2005 02:29:42 +0100 |
|
|
 | > From: "Kim Hansen"
> 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: k@oek.dk
> 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
|
|
|
