{"id":26740,"date":"2025-07-30T12:16:58","date_gmt":"2025-07-30T09:16:58","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/"},"modified":"2025-07-30T12:16:58","modified_gmt":"2025-07-30T09:16:58","slug":"postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/","title":{"rendered":"PostgreSQL: Bir Dizenin Alt Dizeyi \u0130\u00e7erip \u0130\u00e7ermedi\u011fini Kontrol Etme"},"content":{"rendered":"<p># PostgreSQL&#8217;de Alt Dizgi Kontrol\u00fc: String&#8217;ler \u0130\u00e7inde Arama Yapmak<\/p>\n<p>PostgreSQL veritaban\u0131n\u0131zda bir metin s\u00fctununda belirli bir alt dizeyi bulman\u0131z m\u0131 gerekiyor?  Bir \u00fcr\u00fcn a\u00e7\u0131klamas\u0131nda belirli bir kelimeyi ar\u0131yor, bir kullan\u0131c\u0131 yorumunda k\u00fcf\u00fcrl\u00fc ifadeler kontrol ediyor, ya da bir e-posta adresinin belirli bir etki alan\u0131na ait olup olmad\u0131\u011f\u0131n\u0131 do\u011frulamak m\u0131 istiyorsunuz?  Bu makalede, PostgreSQL&#8217;de alt dize kontrol\u00fcn\u00fc ad\u0131m ad\u0131m, yeni ba\u015flayanlardan ileri seviye kullan\u0131c\u0131lara kadar herkes i\u00e7in a\u00e7\u0131klayaca\u011f\u0131z. Ger\u00e7ek d\u00fcnya \u00f6rnekleri, performans optimizasyon teknikleri ve olas\u0131 sorunlar \u00fczerinde duraca\u011f\u0131z.<\/p>\n<p>PostgreSQL, metin verilerini i\u015flemek i\u00e7in g\u00fc\u00e7l\u00fc fonksiyonlar sunar. Bu makalede, bu fonksiyonlar\u0131 kullanarak verimli ve g\u00fcvenilir alt dize aramalar\u0131 nas\u0131l yapaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.  Veritaban\u0131n\u0131zdaki b\u00fcy\u00fck miktarda veri i\u00e7inde h\u0131zl\u0131 ve do\u011fru sonu\u00e7lar elde etmenizi sa\u011flayacak stratejiler ve ipu\u00e7lar\u0131 payla\u015faca\u011f\u0131z.  Haz\u0131rsan\u0131z ba\u015flayal\u0131m!<\/p>\n<p><strong>PostgreSQL&#8217;de Alt Dize Kontrol\u00fc: Nas\u0131l Yap\u0131l\u0131r? (\u00d6\u011frenme Yol Haritas\u0131)<\/strong><\/p>\n<p>Bu yol haritas\u0131, PostgreSQL&#8217;de alt dize kontrol\u00fcn\u00fc \u00f6\u011frenmenizi ad\u0131m ad\u0131m kolayla\u015ft\u0131racak \u015fekilde tasarlanm\u0131\u015ft\u0131r.<\/p>\n<p><strong>Yeni Ba\u015flayan:<\/strong><\/p>\n<p>* <strong>Ad\u0131m 1: Temel <code class=\"language-\">LIKE<\/code> Operat\u00f6r\u00fc:<\/strong>  <code class=\"language-\">LIKE<\/code> operat\u00f6r\u00fc, en basit alt dize arama y\u00f6ntemidir.  Y\u00fczde i\u015fareti (<code class=\"language-\">%<\/code>), herhangi bir karakter dizisini temsil eder. Alt \u00e7izgi (<code class=\"language-\">_<\/code>), tek bir karakteri temsil eder.<\/p>\n<pre class=\"language-sql\"><code>SELECT * FROM urunler WHERE aciklama LIKE '%pamuk%' ; -- A\u00e7\u0131klamada 'pamuk' ge\u00e7en \u00fcr\u00fcnleri se\u00e7er\nSELECT * FROM musteriler WHERE email LIKE '%@gmail.com'; -- Gmail adresi kullanan m\u00fc\u015fterileri se\u00e7er<\/code><\/pre>\n<p>* <strong>Ad\u0131m 2:  <code class=\"language-\">ILIKE<\/code> Operat\u00f6r\u00fc (B\u00fcy\u00fck\/K\u00fc\u00e7\u00fck Harf Duyarl\u0131 Olmayan Arama):<\/strong>  B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyarl\u0131l\u0131\u011f\u0131 \u00f6nemli de\u011filse <code class=\"language-\">ILIKE<\/code> operat\u00f6r\u00fcn\u00fc kullan\u0131n.<\/p>\n<pre class=\"language-sql\"><code>SELECT * FROM urunler WHERE aciklama ILIKE '%pamuk%'; -- B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf farketmeksizin 'pamuk' ge\u00e7en \u00fcr\u00fcnleri se\u00e7er<\/code><\/pre>\n<p>* <strong>Basit Kod \u00d6rne\u011fi:<\/strong>  Bir kitap tablosunda, ba\u015fl\u0131\u011f\u0131 &#8220;Y\u00fcz\u00fcklerin Efendisi&#8221; i\u00e7eren kitaplar\u0131 bulmak i\u00e7in:<\/p>\n<pre class=\"language-sql\"><code>SELECT * FROM kitaplar WHERE baslik LIKE '%Y\u00fcz\u00fcklerin Efendisi%';<\/code><\/pre>\n<p><strong>Orta Seviye:<\/strong><\/p>\n<p>* <strong>Ger\u00e7ek Hayat \u00d6rne\u011fi:<\/strong> Bir e-ticaret sitesinin \u00fcr\u00fcn veritaban\u0131nda, kullan\u0131c\u0131 aramalar\u0131na g\u00f6re sonu\u00e7lar\u0131 filtrelemek i\u00e7in <code class=\"language-\">LIKE<\/code> operat\u00f6r\u00fcn\u00fc kullan\u0131n.  Kullan\u0131c\u0131 &#8220;k\u0131rm\u0131z\u0131 ayakkab\u0131&#8221; ararsa,  <code class=\"language-\">WHERE urun_adi LIKE '%k\u0131rm\u0131z\u0131%' AND urun_adi LIKE '%ayakkab\u0131%'<\/code> sorgusunu kullanabilirsiniz.<\/p>\n<p>* <strong>Optimizasyon \u0130pu\u00e7lar\u0131:<\/strong>  <code class=\"language-\">LIKE<\/code> operat\u00f6r\u00fcn\u00fc <code class=\"language-\">%<\/code> ile ba\u015flayan arama dizeleri i\u00e7in kullanmaktan ka\u00e7\u0131n\u0131n.  PostgreSQL, bu t\u00fcr aramalar\u0131 optimize edemez.  E\u011fer m\u00fcmk\u00fcnse, arama dizisini ba\u015fa koyun veya tam metin arama indeksleri kullan\u0131n.  \u00d6rne\u011fin, <code class=\"language-\">WHERE urun_adi LIKE 'k\u0131rm\u0131z\u0131%'<\/code> daha verimlidir.<\/p>\n<p><strong>\u0130leri Seviye:<\/strong><\/p>\n<p>* <strong>Performans Analizi:<\/strong>  B\u00fcy\u00fck veri k\u00fcmeleri \u00fczerinde <code class=\"language-\">LIKE<\/code> operat\u00f6r\u00fc yava\u015f olabilir.  Performans\u0131 art\u0131rmak i\u00e7in,  tam metin arama indeksleri (<code class=\"language-\">GIN<\/code> veya <code class=\"language-\">GiST<\/code>) olu\u015fturun.  Bu indeksler, metin verileri i\u00e7indeki kelimeleri indeksler ve aramalar\u0131 h\u0131zland\u0131r\u0131r.<\/p>\n<pre class=\"language-sql\"><code>CREATE INDEX idx_urun_adi ON urunler USING gin(to_tsvector('simple', urun_adi));\n\nSELECT * FROM urunler WHERE to_tsquery('simple', 'k\u0131rm\u0131z\u0131 &amp; ayakkab\u0131') @@ idx_urun_adi;<\/code><\/pre>\n<p>* <strong>Edge Case&#8217;ler:<\/strong>  \u00d6zel karakterler i\u00e7eren alt dizeler ararken, ka\u00e7\u0131\u015f karakterleri (<code class=\"language-\">\\<\/code>) kullanman\u0131z gerekebilir.  Ayr\u0131ca, <code class=\"language-\">LIKE<\/code> operat\u00f6r\u00fcn\u00fcn wildcard karakterlerini (<code class=\"language-\">%<\/code>, <code class=\"language-\">_<\/code>)  do\u011fru \u015fekilde kullanman\u0131z \u00f6nemlidir.<\/p>\n<p><strong>PostgreSQL&#8217;de Alt Dize Arama \u0130\u00e7in Fonksiyonlar:  <code class=\"language-\">strpos()<\/code>, <code class=\"language-\">substring()<\/code>, <code class=\"language-\">position()<\/code><\/strong><\/p>\n<p><code class=\"language-\">LIKE<\/code> operat\u00f6r\u00fcn\u00fcn yan\u0131 s\u0131ra, PostgreSQL, alt dize aramalar\u0131 i\u00e7in daha geli\u015fmi\u015f fonksiyonlar sunar.<\/p>\n<p>* <strong><code class=\"language-\">strpos(string, substring)<\/code>:<\/strong>  <code class=\"language-\">substring<\/code>&#8216;in <code class=\"language-\">string<\/code> i\u00e7indeki ilk g\u00f6r\u00fcn\u00fcm\u00fcn\u00fcn pozisyonunu d\u00f6nd\u00fcr\u00fcr.  Pozisyon 1&#8217;den ba\u015flar.  <code class=\"language-\">substring<\/code> bulunmazsa 0 d\u00f6nd\u00fcr\u00fcr.<\/p>\n<pre class=\"language-sql\"><code>SELECT strpos('Merhaba D\u00fcnya', 'D\u00fcnya'); -- 8 d\u00f6nd\u00fcr\u00fcr<\/code><\/pre>\n<p>* <strong><code class=\"language-\">substring(string, start, length)<\/code>:<\/strong>  <code class=\"language-\">string<\/code>&#8216;in <code class=\"language-\">start<\/code> pozisyonundan ba\u015flayarak <code class=\"language-\">length<\/code> uzunlu\u011fundaki alt dizeyi d\u00f6nd\u00fcr\u00fcr.<\/p>\n<pre class=\"language-sql\"><code>SELECT substring('Merhaba D\u00fcnya', 1, 5); -- 'Merha' d\u00f6nd\u00fcr\u00fcr<\/code><\/pre>\n<p>* <strong><code class=\"language-\">position(substring IN string)<\/code>:<\/strong> <code class=\"language-\">strpos()<\/code> fonksiyonuna benzer \u015fekilde, <code class=\"language-\">substring<\/code>&#8216;in <code class=\"language-\">string<\/code> i\u00e7indeki ilk g\u00f6r\u00fcn\u00fcm\u00fcn\u00fcn pozisyonunu d\u00f6nd\u00fcr\u00fcr.<\/p>\n<pre class=\"language-sql\"><code>SELECT position('D\u00fcnya' IN 'Merhaba D\u00fcnya'); -- 8 d\u00f6nd\u00fcr\u00fcr<\/code><\/pre>\n<p><strong>Ger\u00e7ek D\u00fcnya Senaryolar\u0131 ve Vaka \u00c7al\u0131\u015fmalar\u0131<\/strong><\/p>\n<p><strong>Senaryo 1: Spam Filtreleme:<\/strong>  Bir e-posta veritaban\u0131nda, konu sat\u0131r\u0131nda veya metin g\u00f6vdesinde belirli kelimeler i\u00e7eren spam e-postalar\u0131 tespit etmek i\u00e7in <code class=\"language-\">LIKE<\/code> operat\u00f6r\u00fcn\u00fc veya <code class=\"language-\">strpos()<\/code> fonksiyonunu kullanabilirsiniz.  \u00d6rne\u011fin, &#8220;kazand\u0131&#8221;, &#8220;\u00fccretsiz&#8221;, &#8220;garantili&#8221; gibi kelimeler i\u00e7eren e-postalar\u0131 filtreleyebilirsiniz.<\/p>\n<p><strong>Senaryo 2: M\u00fc\u015fteri Destek Sistemi:<\/strong>  M\u00fc\u015fteri destek taleplerinde, belirli bir \u00fcr\u00fcn ad\u0131 veya hata kodu i\u00e7eren talepleri bulmak i\u00e7in <code class=\"language-\">LIKE<\/code> veya di\u011fer fonksiyonlar\u0131 kullanabilirsiniz. Bu, destek ekibinin ilgili talepleri h\u0131zl\u0131ca bulmas\u0131n\u0131 sa\u011flar.<\/p>\n<p><strong>Senaryo 3: Log Dosyas\u0131 Analizi:<\/strong>  Log dosyalar\u0131nda hata mesajlar\u0131n\u0131 veya belirli olaylar\u0131 aramak i\u00e7in <code class=\"language-\">LIKE<\/code> operat\u00f6r\u00fcn\u00fc veya <code class=\"language-\">strpos()<\/code> fonksiyonunu kullanabilirsiniz.  Bu, sistem hatalar\u0131n\u0131n tespit edilmesini ve giderilmesini kolayla\u015ft\u0131r\u0131r.<\/p>\n<p><strong>Performans Optimizasyonu: \u0130ndeksler ve Tam Metin Aramas\u0131<\/strong><\/p>\n<p>B\u00fcy\u00fck veri k\u00fcmeleri \u00fczerinde alt dize aramalar\u0131 yaparken performans kritik \u00f6neme sahiptir.  Aramalar\u0131n h\u0131z\u0131n\u0131 art\u0131rmak i\u00e7in a\u015fa\u011f\u0131daki stratejileri uygulayabilirsiniz:<\/p>\n<p>* <strong>Tam Metin Arama \u0130ndeksleri:<\/strong>  <code class=\"language-\">GIN<\/code> veya <code class=\"language-\">GiST<\/code> indeksleri, metin verileri i\u00e7indeki kelimeleri indeksler ve <code class=\"language-\">LIKE<\/code> operat\u00f6r\u00fcnden \u00e7ok daha h\u0131zl\u0131 aramalar sa\u011flar.  \u00d6zellikle <code class=\"language-\">%<\/code> ile ba\u015flayan arama dizeleri i\u00e7in \u00f6nemli bir performans art\u0131\u015f\u0131 sa\u011flar.<\/p>\n<p>* <strong>Par\u00e7alama (Partial Indexing):<\/strong> Sadece belirli bir ko\u015fulu sa\u011flayan sat\u0131rlar i\u00e7in indeks olu\u015fturarak indeks boyutunu ve bak\u0131m maliyetini azaltabilirsiniz.<\/p>\n<p>* <strong>Sorgular\u0131 Optimize Etme:<\/strong>  <code class=\"language-\">LIKE<\/code> operat\u00f6r\u00fcn\u00fc kullan\u0131rken, <code class=\"language-\">%<\/code> i\u015faretini arama dizisinin ba\u015f\u0131na koymaktan ka\u00e7\u0131n\u0131n.  PostgreSQL, bu t\u00fcr aramalar\u0131 optimize edemez.<\/p>\n<p><strong>PostgreSQL&#8217;de Alt Dize Kontrol\u00fc: S\u0131k\u00e7a Sorulan Sorular (SSS)<\/strong><\/p>\n<p>1. <strong><code class=\"language-\">LIKE<\/code> ve <code class=\"language-\">ILIKE<\/code> aras\u0131ndaki fark nedir?<\/strong> <code class=\"language-\">LIKE<\/code> b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131d\u0131r, <code class=\"language-\">ILIKE<\/code> ise de\u011fildir.<\/p>\n<p>2. <strong>Tam metin arama indeksleri ne zaman kullan\u0131lmal\u0131d\u0131r?<\/strong> B\u00fcy\u00fck veri k\u00fcmeleri \u00fczerinde ve \u00f6zellikle <code class=\"language-\">%<\/code> ile ba\u015flayan arama dizeleri i\u00e7in tam metin arama indeksleri performans\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131r\u0131r.<\/p>\n<p>3. <strong>\u00d6zel karakterler i\u00e7eren alt dizeler nas\u0131l aran\u0131r?<\/strong> \u00d6zel karakterleri ka\u00e7\u0131\u015f karakteri (<code class=\"language-\">\\<\/code>) ile ka\u00e7abilirsiniz.<\/p>\n<p>4. <strong><code class=\"language-\">strpos()<\/code> ve <code class=\"language-\">position()<\/code> fonksiyonlar\u0131 aras\u0131ndaki fark nedir?<\/strong>  Fonksiyonel olarak ayn\u0131d\u0131rlar, sadece parametre s\u0131ralamas\u0131 farkl\u0131d\u0131r.<\/p>\n<p>5. <strong><code class=\"language-\">substring()<\/code> fonksiyonu nas\u0131l kullan\u0131l\u0131r?<\/strong>  Belirli bir ba\u015flang\u0131\u00e7 pozisyonundan belirli bir uzunlukta alt dize ay\u0131klamak i\u00e7in kullan\u0131l\u0131r.<\/p>\n<p><strong>Sonu\u00e7<\/strong><\/p>\n<p>Bu makalede, PostgreSQL&#8217;de alt dize kontrol\u00fcn\u00fc ad\u0131m ad\u0131m ele ald\u0131k.  <code class=\"language-\">LIKE<\/code> operat\u00f6r\u00fcnden tam metin arama indekslerine kadar \u00e7e\u015fitli teknikleri inceledik ve ger\u00e7ek d\u00fcnya senaryolar\u0131na uygulad\u0131k.  Veritaban\u0131n\u0131zdaki metin verilerini etkili bir \u015fekilde i\u015flemek i\u00e7in bu bilgileri kullanabilirsiniz.  Daha fazla bilgi i\u00e7in [fatihsoysal.com](https:\/\/fatihsoysal.com) adresini ziyaret edebilirsiniz.<\/p>\n<p>Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"# PostgreSQL&#8217;de Alt Dizgi Kontrol\u00fc: String&#8217;ler \u0130\u00e7inde Arama Yapmak PostgreSQL veritaban\u0131n\u0131zda bir metin s\u00fctununda belirli bir alt dizeyi&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-26740","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: Bir Dizenin Alt Dizeyi \u0130\u00e7erip \u0130\u00e7ermedi\u011fini Kontrol Etme<\/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-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL: Bir Dizenin Alt Dizeyi \u0130\u00e7erip \u0130\u00e7ermedi\u011fini Kontrol Etme\" \/>\n<meta property=\"og:description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-30T09:16:58+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-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PostgreSQL: Bir Dizenin Alt Dizeyi \u0130\u00e7erip \u0130\u00e7ermedi\u011fini Kontrol Etme\",\"datePublished\":\"2025-07-30T09:16:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/\"},\"wordCount\":959,\"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-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/\",\"name\":\"PostgreSQL: Bir Dizenin Alt Dizeyi \u0130\u00e7erip \u0130\u00e7ermedi\u011fini Kontrol Etme\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-07-30T09:16:58+00:00\",\"description\":\"Hi\u00e7bir etiketi bulunamad\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: Bir Dizenin Alt Dizeyi \u0130\u00e7erip \u0130\u00e7ermedi\u011fini Kontrol Etme\"}]},{\"@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: Bir Dizenin Alt Dizeyi \u0130\u00e7erip \u0130\u00e7ermedi\u011fini Kontrol Etme","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-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/","og_locale":"tr_TR","og_type":"article","og_title":"PostgreSQL: Bir Dizenin Alt Dizeyi \u0130\u00e7erip \u0130\u00e7ermedi\u011fini Kontrol Etme","og_description":"Hi\u00e7bir etiketi bulunamad\u0131.","og_url":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-07-30T09:16:58+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-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PostgreSQL: Bir Dizenin Alt Dizeyi \u0130\u00e7erip \u0130\u00e7ermedi\u011fini Kontrol Etme","datePublished":"2025-07-30T09:16:58+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/"},"wordCount":959,"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-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/","url":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/","name":"PostgreSQL: Bir Dizenin Alt Dizeyi \u0130\u00e7erip \u0130\u00e7ermedi\u011fini Kontrol Etme","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-07-30T09:16:58+00:00","description":"Hi\u00e7bir etiketi bulunamad\u0131.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-dizenin-alt-dizeyi-icerip-icermedigini-kontrol-etme\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: Bir Dizenin Alt Dizeyi \u0130\u00e7erip \u0130\u00e7ermedi\u011fini Kontrol Etme"}]},{"@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\/26740","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=26740"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/26740\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=26740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=26740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=26740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}