> select -(32768::smallint) > > which is why you're getting "smallint out of range." This should work: > > select (-32768)::smallint Exact. Thank you for the answer. But really conter-intuitive.
Cordialement, Jean-Gérard Pailloncy ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
