Eric writes: > 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); > /*********/ I don't know if this is SQL92, but insert into test(id) select 280 where not exists(select id from test); ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
