On Wed, 16 Oct 2002, Albrecht Berger wrote:
> Hello, > I have a statement like this : > > INSERT INTO tab1 (c1, c2, c3) VALUES (1,2, SELECT MAX(pos)+1 FROM tab2); Coalesce is your friend. :) Coalesce((select max(pos)+1 from tab2), 0) should work. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
