Functions / String Functions And Operators

quote_nullable

Returns the given string suitably quoted to be used as a string literal in an SQL statement string; or, if the argument is null, returns NULL.

Reading PG 18current·documented in 19 of 27 versions, 8.4 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

quote_nullable ( text ) → text

Returns the given string suitably quoted to be used as a string literal in an SQL statement string; or, if the argument is null, returns NULL. Embedded single-quotes and backslashes are properly doubled. See also Example 41.1.

quote_nullable(NULL) → NULL

quote_nullable ( anyelement ) → text

Converts the given value to text and then quotes it as a literal; or, if the argument is null, returns NULL. Embedded single-quotes and backslashes are properly doubled.

quote_nullable(42.5) → '42.5'

Version history 10

16 → 17 changed
13 → 14 changed
12 → 13 changed
11 → 12 changed
10 → 11 changed
9.6 → 10 changed
9.5 → 9.6 changed
9.2 → 9.3 changed
8.4 → 9.0 changed
8.3 → 8.4 added

Definition snapshot: b7bd9cda · English manual source