{"id":27616,"date":"2025-08-16T15:15:22","date_gmt":"2025-08-16T12:15:22","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/"},"modified":"2025-08-16T15:15:22","modified_gmt":"2025-08-16T12:15:22","slug":"postgresql-null-degerleri-sifirla-nasil-degistirilir","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/","title":{"rendered":"PostgreSQL: Null De\u011ferleri S\u0131f\u0131rla Nas\u0131l De\u011fi\u015ftirilir"},"content":{"rendered":"<p># PostgreSQL&#8217;de NULL De\u011ferlerini S\u0131f\u0131rlaman\u0131n 7 Yolu<\/p>\n<p>Veri analizinde veya raporlamada s\u0131kl\u0131kla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z bir problem, veritaban\u0131ndaki NULL de\u011ferlerdir.  Bu de\u011ferler, toplama, ortalama hesaplama gibi i\u015flemlerde beklenmedik sonu\u00e7lara yol a\u00e7abilir veya raporlar\u0131n okunabilirli\u011fini d\u00fc\u015f\u00fcrebilir.  PostgreSQL veritaban\u0131n\u0131zda NULL de\u011ferleri nas\u0131l s\u0131f\u0131r ile de\u011fi\u015ftirece\u011finizi ad\u0131m ad\u0131m \u00f6\u011frenece\u011finiz bu kapsaml\u0131 rehberde, temel tekniklerden performans optimizasyonuna kadar her \u015feyi ele alaca\u011f\u0131z.  Bu makale, yeni ba\u015flayanlardan ileri seviye kullan\u0131c\u0131lar\u0131na kadar herkes i\u00e7in faydal\u0131 bilgiler sunmaktad\u0131r.<\/p>\n<p><strong>PostgreSQL&#8217;de NULL De\u011ferlerini S\u0131f\u0131rlama: \u00d6\u011frenme Yol Haritas\u0131<\/strong><\/p>\n<p>Bu rehber, PostgreSQL&#8217;de NULL de\u011ferlerini s\u0131f\u0131r ile de\u011fi\u015ftirmeyi \u00fc\u00e7 farkl\u0131 seviyede ele alacakt\u0131r: Yeni Ba\u015flayan, Orta ve \u0130leri D\u00fczey.  Her seviye, artan karma\u015f\u0131kl\u0131kta konular\u0131 ve uygulamalar\u0131 i\u00e7erecektir.<\/p>\n<p><strong>Yeni Ba\u015flayan:<\/strong>  Temel <code class=\"language-\">COALESCE<\/code> fonksiyonunun kullan\u0131m\u0131 ve basit kod \u00f6rnekleri.<\/p>\n<p><strong>Orta:<\/strong> Ger\u00e7ek d\u00fcnya senaryolar\u0131, performans optimizasyon ipu\u00e7lar\u0131 ve farkl\u0131 fonksiyonlar\u0131n kar\u015f\u0131la\u015ft\u0131rmas\u0131.<\/p>\n<p><strong>\u0130leri D\u00fczey:<\/strong> Performans analizi, edge case&#8217;ler (k\u00f6\u015fe durumlar\u0131) ve b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in optimizasyon stratejileri.<\/p>\n<p><strong>1. Temel Kavramlar: NULL De\u011ferleri ve PostgreSQL<\/strong><\/p>\n<p>PostgreSQL, NULL de\u011ferlerini, bir s\u00fctunun bilinmeyen veya yok de\u011ferini temsil eden \u00f6zel bir de\u011fer olarak ele al\u0131r.  NULL, s\u0131f\u0131r (0) ile ayn\u0131 de\u011fildir. S\u0131f\u0131r, say\u0131sal bir de\u011ferdir, NULL ise veri eksikli\u011fini g\u00f6sterir.  Bu ayr\u0131m, veri i\u015flemede \u00f6nemlidir \u00e7\u00fcnk\u00fc aritmetik i\u015flemlerde NULL de\u011ferleri beklenmedik sonu\u00e7lara yol a\u00e7abilir. \u00d6rne\u011fin, <code class=\"language-\">5 + NULL<\/code> i\u015fleminin sonucu NULL olacakt\u0131r.  Bu nedenle, NULL de\u011ferleri raporlama veya analiz i\u00e7in uygun bir \u015fekilde i\u015flenmelidir.<\/p>\n<p><strong>2. Nas\u0131l Yap\u0131l\u0131r? COALESCE Fonksiyonuyla NULL De\u011ferlerini S\u0131f\u0131rlamak (Yeni Ba\u015flayan)<\/strong><\/p>\n<p>PostgreSQL&#8217;de NULL de\u011ferlerini s\u0131f\u0131r ile de\u011fi\u015ftirmenin en basit yolu <code class=\"language-\">COALESCE<\/code> fonksiyonudur.  Bu fonksiyon, birden fazla arg\u00fcman al\u0131r ve ilk NULL olmayan arg\u00fcman\u0131 d\u00f6nd\u00fcr\u00fcr.  E\u011fer t\u00fcm arg\u00fcmanlar NULL ise, son arg\u00fcman d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/p>\n<p>A\u015fa\u011f\u0131daki \u00f6rnekte, <code class=\"language-\">musteriler<\/code> tablosundaki <code class=\"language-\">siparis_sayisi<\/code> s\u00fctunundaki NULL de\u011ferleri s\u0131f\u0131r ile de\u011fi\u015ftiriyoruz:<\/p>\n<pre class=\"language-sql\"><code>SELECT COALESCE(siparis_sayisi, 0) AS siparis_sayisi\nFROM musteriler;<\/code><\/pre>\n<p>Bu sorgu, <code class=\"language-\">siparis_sayisi<\/code> s\u00fctunundaki NULL de\u011ferleri 0 ile de\u011fi\u015ftirir ve <code class=\"language-\">siparis_sayisi<\/code> olarak adland\u0131r\u0131lan yeni bir s\u00fctun olu\u015fturur.  Tablodaki verileri kal\u0131c\u0131 olarak de\u011fi\u015ftirmek i\u00e7in <code class=\"language-\">UPDATE<\/code> komutunu kullanmal\u0131s\u0131n\u0131z:<\/p>\n<pre class=\"language-sql\"><code>UPDATE musteriler\nSET siparis_sayisi = 0\nWHERE siparis_sayisi IS NULL;<\/code><\/pre>\n<p>Bu komut, <code class=\"language-\">siparis_sayisi<\/code> s\u00fctununda NULL de\u011feri olan t\u00fcm sat\u0131rlar\u0131 g\u00fcnceller ve bu de\u011ferleri 0 olarak de\u011fi\u015ftirir.<\/p>\n<p><strong>3. Ger\u00e7ek D\u00fcnya \u00d6rne\u011fi: E-ticaret Veri Analizi (Orta)<\/strong><\/p>\n<p>Bir e-ticaret \u015firketinin sat\u0131\u015f verilerini ele alal\u0131m.  <code class=\"language-\">satislar<\/code> adl\u0131 bir tabloda, her sat\u0131r bir \u00fcr\u00fcne ait sat\u0131\u015f bilgilerini i\u00e7erir.  <code class=\"language-\">satis_miktari<\/code> s\u00fctunu, belirli bir \u00fcr\u00fcn\u00fcn sat\u0131lan miktar\u0131n\u0131 tutar.  Baz\u0131 \u00fcr\u00fcnler i\u00e7in bu s\u00fctun NULL olabilir, \u00e7\u00fcnk\u00fc bu \u00fcr\u00fcnler hen\u00fcz sat\u0131lmam\u0131\u015ft\u0131r.  Bu NULL de\u011ferleri, toplam sat\u0131\u015f miktar\u0131n\u0131 hesaplamada sorun yaratabilir.<\/p>\n<p><code class=\"language-\">COALESCE<\/code> fonksiyonunu kullanarak bu sorunu \u00e7\u00f6zebiliriz:<\/p>\n<pre class=\"language-sql\"><code>SELECT SUM(COALESCE(satis_miktari, 0)) AS toplam_satis\nFROM satislar;<\/code><\/pre>\n<p>Bu sorgu, <code class=\"language-\">satis_miktari<\/code> s\u00fctunundaki NULL de\u011ferleri 0 olarak kabul ederek toplam sat\u0131\u015f miktar\u0131n\u0131 do\u011fru bir \u015fekilde hesaplar.  Bu, raporlama ve analiz i\u00e7in \u00f6nemli bir iyile\u015ftirmedir.<\/p>\n<p><strong>4. Performans Optimizasyonu \u0130pu\u00e7lar\u0131 (Orta)<\/strong><\/p>\n<p>B\u00fcy\u00fck veri k\u00fcmeleriyle \u00e7al\u0131\u015f\u0131rken, <code class=\"language-\">UPDATE<\/code> komutunun performans\u0131n\u0131 optimize etmek \u00f6nemlidir.  A\u015fa\u011f\u0131daki ipu\u00e7lar\u0131, performans\u0131 art\u0131rman\u0131za yard\u0131mc\u0131 olabilir:<\/p>\n<p>* <strong>\u0130ndeksleme:<\/strong>  <code class=\"language-\">siparis_sayisi<\/code> s\u00fctununa bir indeks eklemek, <code class=\"language-\">WHERE<\/code> ko\u015fulunun daha h\u0131zl\u0131 i\u015flenmesini sa\u011flar.<br \/>\n* <strong>\u0130\u015flem S\u0131ras\u0131:<\/strong>  <code class=\"language-\">UPDATE<\/code> komutu yerine, <code class=\"language-\">COALESCE<\/code> kullanarak bir <code class=\"language-\">SELECT<\/code> sorgusu ile i\u015flemi ger\u00e7ekle\u015ftirmek daha h\u0131zl\u0131 olabilir, \u00f6zellikle b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in.<br \/>\n* <strong>Toplu G\u00fcncellemeler:<\/strong>  M\u00fcmk\u00fcnse, <code class=\"language-\">UPDATE<\/code> komutunu birden fazla sat\u0131r\u0131 ayn\u0131 anda g\u00fcncelleyecek \u015fekilde yaz\u0131n.<\/p>\n<p><strong>5.  CASE WHEN Kullan\u0131m\u0131: Daha Karma\u015f\u0131k Durumlar (Orta)<\/strong><\/p>\n<p><code class=\"language-\">COALESCE<\/code> fonksiyonu sadece NULL de\u011ferlerini tek bir de\u011ferle de\u011fi\u015ftirmek i\u00e7in uygundur.  Daha karma\u015f\u0131k durumlar i\u00e7in <code class=\"language-\">CASE WHEN<\/code> deyimini kullanabiliriz. \u00d6rne\u011fin, <code class=\"language-\">satis_miktari<\/code> s\u00fctunundaki NULL de\u011ferlerini 0 ile, negatif de\u011ferleri ise 0 ile de\u011fi\u015ftirmek istedi\u011fimizi varsayal\u0131m:<\/p>\n<pre class=\"language-sql\"><code>UPDATE satislar\nSET satis_miktari = CASE\n    WHEN satis_miktari IS NULL THEN 0\n    WHEN satis_miktari &lt; 0 THEN 0\n    ELSE satis_miktari\n    END;<\/code><\/pre>\n<p>Bu komut, <code class=\"language-\">satis_miktari<\/code> s\u00fctunundaki NULL ve negatif de\u011ferleri 0 ile de\u011fi\u015ftirir.<\/p>\n<p><strong>6.  NULLIF Fonksiyonu ile Kar\u015f\u0131la\u015ft\u0131rma (\u0130leri D\u00fczey)<\/strong><\/p>\n<p><code class=\"language-\">NULLIF<\/code> fonksiyonu, iki de\u011feri kar\u015f\u0131la\u015ft\u0131r\u0131r ve de\u011ferler e\u015fitse NULL d\u00f6nd\u00fcr\u00fcr, aksi takdirde ilk de\u011feri d\u00f6nd\u00fcr\u00fcr.  Bu fonksiyonu, belirli bir de\u011feri NULL ile de\u011fi\u015ftirmek i\u00e7in kullanabiliriz.  \u00d6rne\u011fin, <code class=\"language-\">satis_miktari<\/code> s\u00fctunundaki -1 de\u011ferlerini NULL ile de\u011fi\u015ftirmek i\u00e7in:<\/p>\n<pre class=\"language-sql\"><code>UPDATE satislar\nSET satis_miktari = NULLIF(satis_miktari, -1);<\/code><\/pre>\n<p>Daha sonra <code class=\"language-\">COALESCE<\/code> kullanarak bu NULL de\u011ferlerini 0 ile de\u011fi\u015ftirebiliriz.<\/p>\n<p><strong>7. Performans Analizi ve B\u00fcy\u00fck Veri K\u00fcmeleri \u0130\u00e7in Stratejiler (\u0130leri D\u00fczey)<\/strong><\/p>\n<p>B\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in, <code class=\"language-\">UPDATE<\/code> i\u015fleminin performans\u0131n\u0131 dikkatlice izlemek \u00f6nemlidir.  <code class=\"language-\">EXPLAIN ANALYZE<\/code> komutu, sorgu plan\u0131n\u0131 ve y\u00fcr\u00fctme s\u00fcresini analiz etmemize yard\u0131mc\u0131 olur.  Ayr\u0131ca,  par\u00e7al\u0131 g\u00fcncellemeler (batch updates) veya materyalize g\u00f6r\u00fcn\u00fcmler (materialized views) gibi teknikleri kullanarak performans\u0131 optimize edebiliriz.  B\u00fcy\u00fck veritabanlar\u0131 i\u00e7in, veritaban\u0131 y\u00f6netim sisteminin sundu\u011fu optimizasyon ara\u00e7lar\u0131n\u0131 ve tekniklerini ara\u015ft\u0131rmak faydal\u0131 olacakt\u0131r.  [Fatih Soysal&#8217;\u0131n](https:\/\/fatihsoysal.com) PostgreSQL performans optimizasyonu ile ilgili makalelerine g\u00f6z atabilirsiniz.<\/p>\n<p><strong>Sonu\u00e7<\/strong><\/p>\n<p>PostgreSQL&#8217;de NULL de\u011ferlerini s\u0131f\u0131r ile de\u011fi\u015ftirmenin birden fazla yolu vard\u0131r.  <code class=\"language-\">COALESCE<\/code>, <code class=\"language-\">CASE WHEN<\/code> ve <code class=\"language-\">NULLIF<\/code> fonksiyonlar\u0131n\u0131 kullanarak farkl\u0131 senaryolara uygun \u00e7\u00f6z\u00fcmler \u00fcretebilirsiniz.  Ancak, b\u00fcy\u00fck veri k\u00fcmeleriyle \u00e7al\u0131\u015f\u0131rken performans optimizasyonuna dikkat etmek \u00f6nemlidir.  Uygun indeksleme, toplu g\u00fcncellemeler ve di\u011fer optimizasyon teknikleri, performans\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131rabilir.<\/p>\n<p><strong>S\u0131k\u00e7a Sorulan Sorular:<\/strong><\/p>\n<p>1. <strong><code class=\"language-\">UPDATE<\/code> komutunu kullanmadan NULL de\u011ferlerini nas\u0131l s\u0131f\u0131rlayabilirim?<\/strong> <code class=\"language-\">SELECT<\/code> sorgular\u0131nda <code class=\"language-\">COALESCE<\/code> fonksiyonunu kullanarak NULL de\u011ferlerini g\u00f6sterim ama\u00e7l\u0131 olarak 0 olarak g\u00f6sterebilirsiniz.<br \/>\n2. <strong>NULL de\u011ferlerini de\u011fi\u015ftirmenin performans etkisi nedir?<\/strong> B\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in performans etkisi \u00f6nemli olabilir. \u0130ndeksleme ve toplu g\u00fcncellemeler performans\u0131 art\u0131rabilir.<br \/>\n3. <strong><code class=\"language-\">COALESCE<\/code> ile <code class=\"language-\">CASE WHEN<\/code> aras\u0131nda ne fark vard\u0131r?<\/strong> <code class=\"language-\">COALESCE<\/code> birden fazla de\u011feri kontrol ederken, <code class=\"language-\">CASE WHEN<\/code> daha karma\u015f\u0131k ko\u015fullar\u0131 ele alabilir.<br \/>\n4. <strong>Hangi y\u00f6ntem en h\u0131zl\u0131d\u0131r?<\/strong>  En h\u0131zl\u0131 y\u00f6ntem, veri k\u00fcmesinin b\u00fcy\u00fckl\u00fc\u011f\u00fcne ve veritaban\u0131 yap\u0131land\u0131rmas\u0131na ba\u011fl\u0131d\u0131r.  <code class=\"language-\">EXPLAIN ANALYZE<\/code> kullanarak performans\u0131 \u00f6l\u00e7mek en iyisidir.<br \/>\n5. <strong>NULL de\u011ferlerini de\u011fi\u015ftirmek veritaban\u0131 b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc etkiler mi?<\/strong>  Veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc etkilememesi i\u00e7in dikkatli olmak gerekir.  \u00d6rne\u011fin, NULL de\u011ferlerinin bir anlam\u0131 varsa, onlar\u0131 0 ile de\u011fi\u015ftirmek yanl\u0131\u015f sonu\u00e7lara yol a\u00e7abilir.<\/p>\n<p>Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"# PostgreSQL&#8217;de NULL De\u011ferlerini S\u0131f\u0131rlaman\u0131n 7 Yolu Veri analizinde veya raporlamada s\u0131kl\u0131kla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z bir problem, veritaban\u0131ndaki NULL de\u011ferlerdir.&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[644],"tags":[],"class_list":{"0":"post-27616","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-postgresql","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL: Null De\u011ferleri S\u0131f\u0131rla Nas\u0131l De\u011fi\u015ftirilir<\/title>\n<meta name=\"description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL: Null De\u011ferleri S\u0131f\u0131rla Nas\u0131l De\u011fi\u015ftirilir\" \/>\n<meta property=\"og:description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-16T12:15:22+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PostgreSQL: Null De\u011ferleri S\u0131f\u0131rla Nas\u0131l De\u011fi\u015ftirilir\",\"datePublished\":\"2025-08-16T12:15:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/\"},\"wordCount\":1115,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/\",\"name\":\"PostgreSQL: Null De\u011ferleri S\u0131f\u0131rla Nas\u0131l De\u011fi\u015ftirilir\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-08-16T12:15:22+00:00\",\"description\":\"Hi\u00e7bir etiketi bulunamad\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: Null De\u011ferleri S\u0131f\u0131rla Nas\u0131l De\u011fi\u015ftirilir\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL: Null De\u011ferleri S\u0131f\u0131rla Nas\u0131l De\u011fi\u015ftirilir","description":"Hi\u00e7bir etiketi bulunamad\u0131.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/","og_locale":"tr_TR","og_type":"article","og_title":"PostgreSQL: Null De\u011ferleri S\u0131f\u0131rla Nas\u0131l De\u011fi\u015ftirilir","og_description":"Hi\u00e7bir etiketi bulunamad\u0131.","og_url":"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-08-16T12:15:22+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"6 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PostgreSQL: Null De\u011ferleri S\u0131f\u0131rla Nas\u0131l De\u011fi\u015ftirilir","datePublished":"2025-08-16T12:15:22+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/"},"wordCount":1115,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["PostgreSQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/","url":"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/","name":"PostgreSQL: Null De\u011ferleri S\u0131f\u0131rla Nas\u0131l De\u011fi\u015ftirilir","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-08-16T12:15:22+00:00","description":"Hi\u00e7bir etiketi bulunamad\u0131.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-null-degerleri-sifirla-nasil-degistirilir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: Null De\u011ferleri S\u0131f\u0131rla Nas\u0131l De\u011fi\u015ftirilir"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/27616","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=27616"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/27616\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=27616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=27616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=27616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}