Résultats pour conditionnelle sql postgresql
Essayez avec l'orthographe conditionnelle sql postgres
https://www.postgresql.org › docs › current › functions-conditional.html
PostgreSQL: Documentation: 17: 9.18. Conditional ExpressionsThe SQL CASE expression is a generic conditional expression, similar to if/else statements in other programming languages: CASE WHEN condition THEN result [ WHEN ... ] [ ELSE result ] END
Table 9.54 shows the specialized operators available for array types. In addition to those, the usual comparison operators shown in Table 9.1 are available for arrays. The comparison operators compare the array contents element-by-element, using the default B-tree comparison function for the element data type, and sort based on the first difference.
https://docs.postgresql.fr › 15 › functions-conditional.html
9.18. Expressions conditionnelles - PostgreSQLCette section décrit les expressions conditionnelles compatibles SQL disponibles dans PostgreSQL.
https://docs.postgresql.fr › 12 › functions-conditional.html
9.17. Expressions conditionnelles - PostgreSQLCette section décrit les expressions conditionnelles respectueuses du standard SQL disponibles avec PostgreSQL.
https://stackoverflow.com › questions › 19029842
sql - IF-THEN-ELSE statements in postgresql - Stack OverflowThe SQL CASE expression is a generic conditional expression, similar to if/else statements in other programming languages. Code snippet specifically answering your question: SELECT field1, field2, CASE. WHEN field1>0 THEN field2/field1. ELSE 0.
https://www.postgresqltutorial.com › postgresql-tutorial › postgresql-case
PostgreSQL CASESummary: in this tutorial, you will learn how to use the PostgreSQL CASE conditional expression to form conditional queries. The PostgreSQL CASE expression is the same as IF/ELSE statement in other programming languages. It allows you to add if-else logic to the query to form a powerful query.
https://postgresql.developpez.com › documentation › francais › 10beta4 › functions-conditional...
9.17. Expressions conditionnelles - Developpez.comCette section décrit les expressions conditionnelles respectueuses du standard SQL disponibles avec PostgreSQL ™.
https://postgrespro.com › docs › postgresql › current › functions-conditional
PostgreSQL : Documentation: 16: 9.18. Conditional ExpressionsSELECT COALESCE(description, short_description, '(none)') ... This returns description if it is not null, otherwise short_description if it is not null, otherwise (none). The arguments must all be convertible to a common data type, which will be the type of the result (see Section 10.5 for details).
https://blog-postgresql.verite.pro › 2017 › 05 › 23 › psql-conditions.html
Les branches if/else/endif dans psql (PostgreSQL 10)Une nouveauté majeure du client psql de PostgreSQL 10 est le support des branchements conditionnels, exprimables via ces nouvelles méta-commandes: \if EXPR1. ... \elif EXPR2. ... \else. ... \endif.
https://www.datacamp.com › tutorial › case-statements-in-postgresql
CASE Statements in PostgreSQL - DataCampIn this tutorial, you'll learn how to write conditional queries in PostgreSQL using the PostgreSQL CASE conditional expression.
https://www.postgresql.org › docs › current › functions-comparison.html
9.2. Comparison Functions and Operators - PostgreSQLThese comparison operators are available for all built-in data types that have a natural ordering, including numeric, string, and date/time types. In addition, arrays, composite types, and ranges can be compared if their component data types are comparable. It is usually possible to compare values of related data types as well; for ...