Re: [SQL] Inserting or Deleting conditionally

2005-01-17 Thread Richard Huxton
KÖPFERL Robert wrote: Hi, coming from imperative programming paradigma, I'm currently trying to express something like that in _SQL_: SQL is not an imperative language - each SQL statement is an expression to be evaluated. It should be atomic and like an API for a user. I'm therefore writing func

[SQL] Inserting or Deleting conditionally

2005-01-17 Thread KÖPFERL Robert
Hi, coming from imperative programming paradigma, I'm currently trying to express something like that in _SQL_: It should be atomic and like an API for a user. I'm therefore writing functions: CRETE FUNC... c := SELECT x,y,z FROM table_a WHERE... IF COUNT(c)=1 then INSERT / DELETE ... W