{"id":25770,"date":"2025-07-13T06:17:32","date_gmt":"2025-07-13T03:17:32","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/"},"modified":"2025-07-13T06:17:32","modified_gmt":"2025-07-13T03:17:32","slug":"postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/","title":{"rendered":"PostgreSQL: Bir Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme"},"content":{"rendered":"<p># PostgreSQL&#8217;de Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme<\/p>\n<p>PostgreSQL veritaban\u0131n\u0131zda tam say\u0131 (integer) tipinde saklanan bir veriyi ondal\u0131kl\u0131 say\u0131 (decimal) tipinde kullanman\u0131z m\u0131 gerekiyor?  \u00d6rne\u011fin, \u00fcr\u00fcn fiyatlar\u0131n\u0131 tam say\u0131 olarak sakl\u0131yor ancak raporlamalarda ondal\u0131k g\u00f6sterimle \u00e7al\u0131\u015fman\u0131z m\u0131 gerekiyor?  Ya da bir hesaplama sonucunda tam say\u0131 yerine daha hassas bir ondal\u0131k say\u0131ya m\u0131 ihtiyac\u0131n\u0131z var? Bu makalede, PostgreSQL&#8217;de tam say\u0131lar\u0131 ondal\u0131kl\u0131 say\u0131lara d\u00f6n\u00fc\u015ft\u00fcrmenin farkl\u0131 y\u00f6ntemlerini, performans optimizasyonunu ve olas\u0131 sorunlar\u0131 ad\u0131m ad\u0131m ele alaca\u011f\u0131z.  Farkl\u0131 deneyim seviyelerine g\u00f6re haz\u0131rlanan bu rehberle, PostgreSQL&#8217;de say\u0131sal d\u00f6n\u00fc\u015f\u00fcmleri ustala\u015facaks\u0131n\u0131z.<\/p>\n<p><strong>Temel Kavramlar: Tam Say\u0131lar ve Ondal\u0131kl\u0131 Say\u0131lar PostgreSQL&#8217;de<\/strong><\/p>\n<p>PostgreSQL, farkl\u0131 say\u0131sal veri tiplerini destekler. Bunlardan en yayg\u0131n olanlar\u0131 <code class=\"language-\">INTEGER<\/code> (tam say\u0131) ve <code class=\"language-\">NUMERIC<\/code> (ondal\u0131kl\u0131 say\u0131) tipleridir. <code class=\"language-\">INTEGER<\/code>, tam say\u0131lar\u0131 kaydederken, <code class=\"language-\">NUMERIC<\/code> ise ondal\u0131kl\u0131 say\u0131lar\u0131 y\u00fcksek hassasiyetle saklar.  <code class=\"language-\">NUMERIC<\/code> tipi, <code class=\"language-\">DECIMAL<\/code> ile e\u015fanlaml\u0131d\u0131r ve genellikle tercih edilen ondal\u0131k say\u0131 tipidir \u00e7\u00fcnk\u00fc daha esnektir ve depolama gereksinimlerine g\u00f6re otomatik olarak ayarlanabilir.  <code class=\"language-\">FLOAT<\/code> ve <code class=\"language-\">DOUBLE PRECISION<\/code> gibi kayan noktal\u0131 say\u0131 tipleri de vard\u0131r, ancak bunlar hassasiyet a\u00e7\u0131s\u0131ndan <code class=\"language-\">NUMERIC<\/code>&#8216;ten daha az g\u00fcvenilirdir, \u00f6zellikle finansal uygulamalar gibi hassas hesaplamalar gerekti\u011finde.  Bu nedenle, ondal\u0131k say\u0131lar i\u00e7in genellikle <code class=\"language-\">NUMERIC<\/code> tercih edilir.<\/p>\n<p><strong>PostgreSQL&#8217;de Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme: Ad\u0131m Ad\u0131m Uygulama<\/strong><\/p>\n<p>PostgreSQL&#8217;de tam say\u0131y\u0131 ondal\u0131kl\u0131 say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrmenin en basit yolu, <code class=\"language-\">CAST<\/code> operat\u00f6r\u00fcn\u00fc kullanmakt\u0131r.  Bu operat\u00f6r, bir veri t\u00fcr\u00fcn\u00fc ba\u015fka bir veri t\u00fcr\u00fcne d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n<p><strong>Yeni Ba\u015flayan:<\/strong><\/p>\n<p><strong>Ad\u0131m 1:<\/strong> Bir tam say\u0131 de\u011feri tan\u0131mlay\u0131n.<\/p>\n<pre class=\"language-sql\"><code>SELECT 10;  -- Tam say\u0131 de\u011feri<\/code><\/pre>\n<p><strong>Ad\u0131m 2:<\/strong> <code class=\"language-\">CAST<\/code> operat\u00f6r\u00fcn\u00fc kullanarak tam say\u0131y\u0131 <code class=\"language-\">NUMERIC<\/code> tipine d\u00f6n\u00fc\u015ft\u00fcr\u00fcn.  \u0130stedi\u011finiz ondal\u0131k basamak say\u0131s\u0131n\u0131 belirtmek i\u00e7in <code class=\"language-\">NUMERIC(p,s)<\/code>  s\u00f6zdizimini kullanabilirsiniz.  Burada <code class=\"language-\">p<\/code> toplam basamak say\u0131s\u0131n\u0131, <code class=\"language-\">s<\/code> ise ondal\u0131k basamaktan sonraki basamak say\u0131s\u0131n\u0131 temsil eder.<\/p>\n<pre class=\"language-sql\"><code>SELECT CAST(10 AS NUMERIC); -- 10.0 olarak d\u00f6nd\u00fcr\u00fcr\nSELECT CAST(10 AS NUMERIC(5,2)); -- 10.00 olarak d\u00f6nd\u00fcr\u00fcr<\/code><\/pre>\n<p><strong>Basit Kod \u00d6rne\u011fi:<\/strong><\/p>\n<p>Bir tabloda tam say\u0131 olarak saklanan <code class=\"language-\">fiyat<\/code> s\u00fctununu ondal\u0131kl\u0131 say\u0131ya d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in:<\/p>\n<pre class=\"language-sql\"><code>SELECT CAST(fiyat AS NUMERIC(10,2)) AS ondalik_fiyat FROM urunler;<\/code><\/pre>\n<p>Bu sorgu, <code class=\"language-\">urunler<\/code> tablosundaki <code class=\"language-\">fiyat<\/code> s\u00fctunundaki t\u00fcm de\u011ferleri 10 basamakl\u0131 ve 2 ondal\u0131k basamakl\u0131 <code class=\"language-\">NUMERIC<\/code> de\u011ferlerine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve <code class=\"language-\">ondalik_fiyat<\/code> olarak adland\u0131r\u0131lan yeni bir s\u00fctunda g\u00f6sterir.<\/p>\n<p><strong>Ger\u00e7ek Hayatta Tam Say\u0131dan Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme: \u00d6rnek Senaryolar ve Optimizasyon \u0130pu\u00e7lar\u0131<\/strong><\/p>\n<p><strong>Orta Seviye:<\/strong><\/p>\n<p><strong>Ger\u00e7ek Hayat \u00d6rne\u011fi:<\/strong><\/p>\n<p>Bir e-ticaret sitesinin veritaban\u0131nda \u00fcr\u00fcn fiyatlar\u0131 tam say\u0131 olarak (\u00f6rne\u011fin, sent cinsinden) saklan\u0131yor olsun.  Ancak, web sitesinde \u00fcr\u00fcn fiyatlar\u0131 ondal\u0131k g\u00f6sterimde (TL cinsinden) g\u00f6sterilmesi gerekiyor.  Bu durumda, <code class=\"language-\">CAST<\/code> operat\u00f6r\u00fc kullan\u0131larak fiyatlar ondal\u0131kl\u0131 say\u0131lara d\u00f6n\u00fc\u015ft\u00fcr\u00fclebilir.<\/p>\n<pre class=\"language-sql\"><code>SELECT CAST(fiyat AS NUMERIC(10,2))\/100 AS fiyat_tl FROM urunler;<\/code><\/pre>\n<p>Bu sorgu, <code class=\"language-\">fiyat<\/code> s\u00fctunundaki sent cinsinden fiyatlar\u0131 TL cinsine d\u00f6n\u00fc\u015ft\u00fcr\u00fcr ve iki ondal\u0131k basamak g\u00f6sterir.<\/p>\n<p><strong>Optimizasyon \u0130pu\u00e7lar\u0131:<\/strong><\/p>\n<p>* <strong>\u0130ndeksler:<\/strong> E\u011fer d\u00f6n\u00fc\u015ft\u00fcrme i\u015flemini s\u0131k s\u0131k yap\u0131yorsan\u0131z, performans\u0131 art\u0131rmak i\u00e7in d\u00f6n\u00fc\u015ft\u00fcr\u00fclen s\u00fctunda bir indeks olu\u015fturmay\u0131 d\u00fc\u015f\u00fcnebilirsiniz. Ancak, bu indeksleme her zaman performans art\u0131\u015f\u0131 sa\u011flamaz ve baz\u0131 durumlarda performans\u0131 d\u00fc\u015f\u00fcrebilir.  \u0130ndeks olu\u015fturmadan \u00f6nce performans testleri yapman\u0131z \u00f6nerilir.<br \/>\n* <strong>G\u00f6r\u00fcn\u00fcm (View) Kullan\u0131m\u0131:<\/strong>  S\u0131k\u00e7a kullan\u0131lan d\u00f6n\u00fc\u015ft\u00fcrme i\u015flemlerini bir g\u00f6r\u00fcn\u00fcm (view) i\u00e7inde kaps\u00fclleyerek, tekrarlanan d\u00f6n\u00fc\u015ft\u00fcrme i\u015flemlerinden ka\u00e7\u0131nabilirsiniz ve sorgu yazmay\u0131 kolayla\u015ft\u0131rabilirsiniz.<\/p>\n<pre class=\"language-sql\"><code>CREATE VIEW urunler_ondalik_fiyat AS\nSELECT *, CAST(fiyat AS NUMERIC(10,2))\/100 AS fiyat_tl FROM urunler;<\/code><\/pre>\n<p><strong>\u0130leri D\u00fczey Teknikler: Performans Analizi ve \u00d6zel Durumlar (Edge Cases)<\/strong><\/p>\n<p><strong>\u0130leri D\u00fczey:<\/strong><\/p>\n<p><strong>Performans Analizi:<\/strong><\/p>\n<p>B\u00fcy\u00fck veri k\u00fcmeleri \u00fczerinde <code class=\"language-\">CAST<\/code> i\u015flemi performans\u0131 etkileyebilir.  Performans\u0131 analiz etmek i\u00e7in <code class=\"language-\">EXPLAIN ANALYZE<\/code> komutunu kullanabilirsiniz.  \u00d6rne\u011fin:<\/p>\n<pre class=\"language-sql\"><code>EXPLAIN ANALYZE SELECT CAST(fiyat AS NUMERIC(10,2)) FROM urunler;<\/code><\/pre>\n<p>Bu komut, sorgunun y\u00fcr\u00fct\u00fclme plan\u0131n\u0131 ve s\u00fcresini g\u00f6sterir.  Sonu\u00e7lar\u0131 inceleyerek, sorgunun performans\u0131n\u0131 iyile\u015ftirmek i\u00e7in gerekli ad\u0131mlar\u0131 belirleyebilirsiniz.  \u00d6rne\u011fin, indeksleme veya farkl\u0131 bir sorgu stratejisi kullanman\u0131z gerekebilir.<\/p>\n<p><strong>Edge Cases:<\/strong><\/p>\n<p>* <strong>\u00c7ok B\u00fcy\u00fck Say\u0131lar:<\/strong> \u00c7ok b\u00fcy\u00fck tam say\u0131lar\u0131 <code class=\"language-\">NUMERIC<\/code> tipine d\u00f6n\u00fc\u015ft\u00fcr\u00fcrken, <code class=\"language-\">NUMERIC<\/code> tipinin hassasiyet s\u0131n\u0131rlamalar\u0131n\u0131 g\u00f6z \u00f6n\u00fcnde bulundurman\u0131z gerekir.  \u00c7ok b\u00fcy\u00fck say\u0131lar i\u00e7in <code class=\"language-\">NUMERIC<\/code> tipi yetersiz kalabilir ve veri kayb\u0131na yol a\u00e7abilir.  Bu gibi durumlarda, daha uygun bir veri tipi kullanman\u0131z gerekebilir.<br \/>\n* <strong>NULL De\u011ferler:<\/strong>  <code class=\"language-\">NULL<\/code> de\u011ferleri <code class=\"language-\">CAST<\/code> i\u015flemiyle d\u00f6n\u00fc\u015ft\u00fcr\u00fcl\u00fcrken, sonu\u00e7 yine <code class=\"language-\">NULL<\/code> olur.  Bu durumu dikkate alarak sorgular\u0131n\u0131z\u0131 yazman\u0131z \u00f6nemlidir.  <code class=\"language-\">COALESCE<\/code> fonksiyonu ile <code class=\"language-\">NULL<\/code> de\u011ferlerini ba\u015fka bir de\u011ferle de\u011fi\u015ftirebilirsiniz.<\/p>\n<p><strong>PostgreSQL&#8217;de Tam Say\u0131dan Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme: Sonu\u00e7 ve S\u0131k\u00e7a Sorulan Sorular<\/strong><\/p>\n<p>Bu makalede, PostgreSQL&#8217;de tam say\u0131lar\u0131 ondal\u0131kl\u0131 say\u0131lara d\u00f6n\u00fc\u015ft\u00fcrmenin farkl\u0131 y\u00f6ntemlerini, performans optimizasyonunu ve olas\u0131 sorunlar\u0131 ele ald\u0131k. <code class=\"language-\">CAST<\/code> operat\u00f6r\u00fc, basit ve etkili bir y\u00f6ntem olsa da, b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in performans optimizasyonu ve edge case&#8217;leri dikkate almak \u00f6nemlidir.  <code class=\"language-\">NUMERIC<\/code> tipi, ondal\u0131kl\u0131 say\u0131lar i\u00e7in genel olarak tercih edilen tiptir, ancak ihtiya\u00e7lar\u0131n\u0131za g\u00f6re <code class=\"language-\">FLOAT<\/code> veya <code class=\"language-\">DOUBLE PRECISION<\/code> gibi di\u011fer tipleri de kullanabilirsiniz.  Uygulamada, verilerinizin \u00f6zelliklerini ve performans gereksinimlerinizi g\u00f6z \u00f6n\u00fcnde bulundurarak en uygun y\u00f6ntemi se\u00e7meniz \u00f6nemlidir.<\/p>\n<p><strong>S\u0131k\u00e7a Sorulan Sorular:<\/strong><\/p>\n<p>1. <strong><code class=\"language-\">NUMERIC<\/code> ve <code class=\"language-\">DECIMAL<\/code> tipleri aras\u0131nda fark var m\u0131?<\/strong>  PostgreSQL&#8217;de <code class=\"language-\">NUMERIC<\/code> ve <code class=\"language-\">DECIMAL<\/code> e\u015fanlaml\u0131d\u0131r ve ayn\u0131 veri tipini temsil eder.<\/p>\n<p>2. <strong>Ondal\u0131k basamak say\u0131s\u0131n\u0131 nas\u0131l kontrol edebilirim?<\/strong> <code class=\"language-\">CAST(tam_sayi AS NUMERIC(p,s))<\/code>  s\u00f6zdiziminde <code class=\"language-\">s<\/code> parametresi ondal\u0131k basamak say\u0131s\u0131n\u0131 belirler.<\/p>\n<p>3. <strong><code class=\"language-\">CAST<\/code> i\u015flemi performans\u0131 nas\u0131l etkiler?<\/strong> B\u00fcy\u00fck veri k\u00fcmeleri i\u00e7in performans d\u00fc\u015f\u00fc\u015f\u00fcne neden olabilir.  \u0130ndeksleme veya g\u00f6r\u00fcn\u00fcm kullan\u0131m\u0131 performans\u0131 art\u0131rabilir.<\/p>\n<p>4. <strong><code class=\"language-\">NULL<\/code> de\u011ferleri nas\u0131l ele alabilirim?<\/strong> <code class=\"language-\">COALESCE<\/code> fonksiyonu ile <code class=\"language-\">NULL<\/code> de\u011ferlerini varsay\u0131lan bir de\u011ferle de\u011fi\u015ftirebilirsiniz.<\/p>\n<p>5. <strong>\u00c7ok b\u00fcy\u00fck say\u0131lar i\u00e7in hangi veri tipi daha uygundur?<\/strong> \u00c7ok b\u00fcy\u00fck say\u0131lar i\u00e7in <code class=\"language-\">NUMERIC<\/code> tipinin hassasiyet s\u0131n\u0131rlamalar\u0131n\u0131 g\u00f6z \u00f6n\u00fcnde bulundurman\u0131z ve gerekirse alternatif bir \u00e7\u00f6z\u00fcm araman\u0131z gerekir.  Daha y\u00fcksek hassasiyet gerektiren durumlarda, \u00f6zel k\u00fct\u00fcphaneler veya uzant\u0131lar kullan\u0131labilir.  Bu konuda 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 Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme PostgreSQL veritaban\u0131n\u0131zda tam say\u0131 (integer) tipinde saklanan bir veriyi ondal\u0131kl\u0131 say\u0131&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-25770","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 Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme<\/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-tam-sayiyi-ondalikli-sayiya-donusturme\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL: Bir Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme\" \/>\n<meta property=\"og:description\" content=\"Hi\u00e7bir etiketi bulunamad\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-13T03:17:32+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-tam-sayiyi-ondalikli-sayiya-donusturme\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PostgreSQL: Bir Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme\",\"datePublished\":\"2025-07-13T03:17:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/\"},\"wordCount\":1074,\"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-tam-sayiyi-ondalikli-sayiya-donusturme\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/\",\"name\":\"PostgreSQL: Bir Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-07-13T03:17:32+00:00\",\"description\":\"Hi\u00e7bir etiketi bulunamad\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL: Bir Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme\"}]},{\"@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 Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme","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-tam-sayiyi-ondalikli-sayiya-donusturme\/","og_locale":"tr_TR","og_type":"article","og_title":"PostgreSQL: Bir Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme","og_description":"Hi\u00e7bir etiketi bulunamad\u0131.","og_url":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-07-13T03:17:32+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-tam-sayiyi-ondalikli-sayiya-donusturme\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PostgreSQL: Bir Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme","datePublished":"2025-07-13T03:17:32+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/"},"wordCount":1074,"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-tam-sayiyi-ondalikli-sayiya-donusturme\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/","url":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/","name":"PostgreSQL: Bir Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-07-13T03:17:32+00:00","description":"Hi\u00e7bir etiketi bulunamad\u0131.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-bir-tam-sayiyi-ondalikli-sayiya-donusturme\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL: Bir Tam Say\u0131y\u0131 Ondal\u0131kl\u0131 Say\u0131ya D\u00f6n\u00fc\u015ft\u00fcrme"}]},{"@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\/25770","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=25770"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/25770\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=25770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=25770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=25770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}