Content deleted Content added
Ce Tags: Mobile edit Mobile web edit Advanced mobile edit |
Sohom Datta (talk | contribs) →Arithmetic operations: add a specific citation |
||
Line 53:
'Fish ' || NULL || 'Chips' -- Result is NULL
</syntaxhighlight>
This is not true for all database implementations. In an Oracle RDBMS for example NULL and the empty string are considered the same thing and therefore 'Fish ' || NULL || 'Chips' results in 'Fish Chips'.<ref>{{Cite web |date=2022-05-23 |title=Handle empty strings when migrating from Oracle to PostgreSQL {{!}} AWS Database Blog |url=https://aws.amazon.com/blogs/database/handle-empty-strings-when-migrating-from-oracle-to-postgresql/ |access-date=2023-12-30 |website=aws.amazon.com |language=en-US}}</ref>
== Comparisons with NULL and the three-valued logic (3VL) ==
| |||