PostgreSQL 8.0 Documentationkey word that contains digits or starts or ends with an underscore, so identifiers of this form are safe against possible conflict with future extensions of the standard. The system uses no more than NAMEDATALEN-1 to avoid division by zero in a WHERE clause: SELECT ... WHERE x < > 0 AND y/x > 1.5; But this is safe: SELECT ... WHERE CASE WHEN x < > 0 THEN y/x > 1.5 ELSE false END; A CASE construct used in this and back- slashes embedded in element values will be backslash-escaped. For numeric data types it is safe to assume that double quotes will never appear, but for textual data types one should be prepared0 码力 | 1422 页 | 9.92 MB | 1 年前3
PostgreSQL 8.0 Documentationkey word that contains digits or starts or ends with an underscore, so identifiers of this form are safe against possible conflict with future extensions of the standard. The system uses no more than NAMEDATALEN-1 to avoid division by zero in a WHERE clause: SELECT ... WHERE x < > 0 AND y/x > 1.5; But this is safe: SELECT ... WHERE CASE WHEN x < > 0 THEN y/x > 1.5 ELSE false END; A CASE construct used in this and backslashes embedded in element values will be backslash-escaped. For numeric data types it is safe to assume that double quotes will never appear, but for textual data types one should be prepared0 码力 | 1332 页 | 9.76 MB | 1 年前3
PostgreSQL 8.1.11 Documentationkey word that contains digits or starts or ends with an underscore, so identifiers of this form are safe against possible conflict with future extensions of the standard. The system uses no more than NAMEDATALEN-1 to avoid division by zero in a WHERE clause: SELECT ... WHERE x < > 0 AND y/x > 1.5; But this is safe: SELECT ... WHERE CASE WHEN x < > 0 THEN y/x > 1.5 ELSE false END; A CASE construct used in this and back- slashes embedded in element values will be backslash-escaped. For numeric data types it is safe to assume that double quotes will never appear, but for textual data types one should be prepared0 码力 | 1582 页 | 12.19 MB | 1 年前3
PostgreSQL 8.1 Documentationkey word that contains digits or starts or ends with an underscore, so identifiers of this form are safe against possible conflict with future extensions of the standard. The system uses no more than NAMEDATALEN-1 to avoid division by zero in a WHERE clause: SELECT ... WHERE x < > 0 AND y/x > 1.5; But this is safe: SELECT ... WHERE CASE WHEN x < > 0 THEN y/x > 1.5 ELSE false END; A CASE construct used in this and back- slashes embedded in element values will be backslash-escaped. For numeric data types it is safe to assume that double quotes will never appear, but for textual data types one should be prepared0 码力 | 1548 页 | 11.54 MB | 1 年前3
PostgreSQL 8.2 Documentationkey word that contains digits or starts or ends with an underscore, so identifiers of this form are safe against possible conflict with future extensions of the standard. The system uses no more than NAMEDATALEN-1 to avoid division by zero in a WHERE clause: SELECT ... WHERE x < > 0 AND y/x > 1.5; But this is safe: SELECT ... WHERE CASE WHEN x < > 0 THEN y/x > 1.5 ELSE false END; A CASE construct used in this and backslashes embedded in element values will be backslash-escaped. For numeric data types it is safe to assume that double quotes will never appear, but for textual data types one should be prepared0 码力 | 1762 页 | 5.43 MB | 1 年前3
PostgreSQL 8.2 Documentationkey word that contains digits or starts or ends with an underscore, so identifiers of this form are safe against possible conflict with future extensions of the standard. The system uses no more than NAMEDATALEN-1 to avoid division by zero in a WHERE clause: SELECT ... WHERE x < > 0 AND y/x > 1.5; But this is safe: SELECT ... WHERE CASE WHEN x < > 0 THEN y/x > 1.5 ELSE false END; A CASE construct used in this and backslashes embedded in element values will be backslash-escaped. For numeric data types it is safe to assume that double quotes will never appear, but for textual data types one should be prepared0 码力 | 1748 页 | 13.12 MB | 1 年前3
PostgreSQL 17beta1 A4 Documentationkey word that contains digits or starts or ends with an underscore, so identifiers of this form are safe against possible conflict with future extensions of the standard. 33 SQL Syntax The system uses trying to avoid division by zero in a WHERE clause: SELECT ... WHERE x > 0 AND y/x > 1.5; But this is safe: SELECT ... WHERE CASE WHEN x > 0 THEN y/x > 1.5 ELSE false END; A CASE construct used in this fashion 'mallory'; UPDATE information SET info = 'secret from mallory' WHERE group_id = 2; COMMIT; That looks safe; there is no window wherein mallory should be able to see the “secret from mallory” string. However0 码力 | 3017 页 | 14.45 MB | 1 年前3
PostgreSQL 17beta1 US Documentationkey word that contains digits or starts or ends with an underscore, so identifiers of this form are safe against possible conflict with future extensions of the standard. The system uses no more than NAMEDATALEN-1 trying to avoid division by zero in a WHERE clause: SELECT ... WHERE x > 0 AND y/x > 1.5; But this is safe: SELECT ... WHERE CASE WHEN x > 0 THEN y/x > 1.5 ELSE false END; A CASE construct used in this fashion 'mallory'; UPDATE information SET info = 'secret from mallory' WHERE group_id = 2; COMMIT; That looks safe; there is no window wherein mallory should be able to see the “secret from mallory” string. However0 码力 | 3188 页 | 14.32 MB | 1 年前3
PostgreSQL 14.10 Documentationkey word that contains digits or starts or ends with an underscore, so identifiers of this form are safe against possible conflict with future extensions of the standard. 33 SQL Syntax The system uses division by zero in a WHERE clause: 54 SQL Syntax SELECT ... WHERE x > 0 AND y/x > 1.5; But this is safe: SELECT ... WHERE CASE WHEN x > 0 THEN y/x > 1.5 ELSE false END; A CASE construct used in this fashion 'mallory'; UPDATE information SET info = 'secret from mallory' WHERE group_id = 2; COMMIT; That looks safe; there is no window wherein mallory should be able to see the “secret from mallory” string. However0 码力 | 2871 页 | 13.38 MB | 1 年前3
PostgreSQL 13.13 Documentationkey word that contains digits or starts or ends with an underscore, so identifiers of this form are safe against possible conflict with future extensions of the standard. 33 SQL Syntax The system uses trying to avoid division by zero in a WHERE clause: SELECT ... WHERE x > 0 AND y/x > 1.5; But this is safe: SELECT ... WHERE CASE WHEN x > 0 THEN y/x > 1.5 ELSE false END; A CASE construct used in this fashion 'mallory'; UPDATE information SET info = 'secret from mallory' WHERE group_id = 2; COMMIT; That looks safe; there is no window wherein mallory should be able to see the “secret from mallory” string. However0 码力 | 2782 页 | 13.00 MB | 1 年前3
共 40 条
- 1
- 2
- 3
- 4













