On Thu, Jul 28, 2005 at 02:05:30PM +0100, Mansion wrote:
>
> on the table rien with the column "ordre" (int type)
> When i write :
> INSERT INTO rien (ordre) SELECT NULL UNION ALL SELECT NULL
> i have the error :
> column "ordre" is of type integer but expression is of type text
The complete error message gives a hint about how to solve this problem:
CREATE TABLE rien (ordre integer);
INSERT INTO rien (ordre) SELECT NULL UNION ALL SELECT NULL;
ERROR: column "ordre" is of type integer but expression is of type text
HINT: You will need to rewrite or cast the expression.
For more information see "UNION, CASE, and ARRAY Type Resolution"
in the documentation:
http://www.postgresql.org/docs/8.0/static/typeconv-union-case.html
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
