Sprawdzanie postgresql null

Przykłady kodu

3
0

postgresql jeśli null to 0

select coalesce(avg(bar), 0) from foo;
2
0

postgres ustawić null

UPDATE table1
SET column_a IS NULL
WHERE column_b = 'XXX';

W innych językach

Ta strona jest w innych językach

Русский
..................................................................................................................
English
..................................................................................................................
Italiano
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
中文
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................
Балгарскі
..................................................................................................................
Íslensk
..................................................................................................................