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/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
