postgresql if example
If the ELSE clause is omitted and no condition is true, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... ,If the ELSE clause is omitted and no condition matches, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... ,If the ELSE clause is omitted and no condition is true, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... ,If the ELSE clause is omitted and no condition is true, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... ,If you declared the function to return void, a RETURN statement can be used to exit the ... Example: IF v_user_id <> 0 THEN UPDATE users SET email = v_email ... ,If the ELSE clause is omitted and no condition is true, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... ,If the ELSE clause is omitted and no condition is true, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... ,If the ELSE clause is omitted and no condition is true, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... , , So in your above example the code should look as follows: IF select count(*) from orders > 0 THEN DELETE from orders ELSE INSERT INTO ...
| 相關軟體 PostgreSQL (64-bit) 資訊 | |
|---|---|
 postgresql if example 相關參考資料
Documentation: 10: 9.17. Conditional Expressions - PostgreSQL
If the ELSE clause is omitted and no condition is true, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... https://www.postgresql.org Documentation: 8.2: Conditional Expressions - PostgreSQL
If the ELSE clause is omitted and no condition matches, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... https://www.postgresql.org Documentation: 8.4: Conditional Expressions - PostgreSQL
If the ELSE clause is omitted and no condition is true, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... https://www.postgresql.org Documentation: 9.1: Conditional Expressions - PostgreSQL
If the ELSE clause is omitted and no condition is true, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... https://www.postgresql.org Documentation: 9.1: Control Structures - PostgreSQL
If you declared the function to return void, a RETURN statement can be used to exit the ... Example: IF v_user_id <> 0 THEN UPDATE users SET email = v_email ... https://www.postgresql.org Documentation: 9.2: Conditional Expressions - PostgreSQL
If the ELSE clause is omitted and no condition is true, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... https://www.postgresql.org Documentation: 9.4: Conditional Expressions - PostgreSQL
If the ELSE clause is omitted and no condition is true, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... https://www.postgresql.org Documentation: 9.5: Conditional Expressions - PostgreSQL
If the ELSE clause is omitted and no condition is true, the result is null. An example: SELECT * FROM test; a --- 1 2 3 SELECT a, CASE WHEN a=1 THEN 'one' ... https://www.postgresql.org PLpgSQL IF Statement - PostgreSQL Tutorial
https://www.postgresqltutorial PostgreSQL IF statement - Stack Overflow
So in your above example the code should look as follows: IF select count(*) from orders > 0 THEN DELETE from orders ELSE INSERT INTO ... https://stackoverflow.com |