I can realize this function in the SYBase,but How can i do it in the PostgreSQL? /****SQL***/ if not exists(select id from test) insert into test(id) values (280); /*********/ _____________________________________________ 数码产品新上市,酷 http://shopping.263.net/category21.htm 精品小家电迎夏热卖 http://shopping.263.net/category23.htm ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]