<div>Selamlar Cem Bey,</div><div> </div><div>PostgreSQL'de class_mapping_tab şeklinde Oracle'e daki gibi yeni bir veritipi yaratmaya gerek yok. class_mapping'i doğrudan bir dizi olarak kullanabilirsiniz. Fonksiyon içerisindeki örnek bir kullanım aşağıdaki gibi olabilir.</div><div> </div><div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;">CREATE TYPE class_mapping AS</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;"> (id bigint,</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;"> klasse bigint,</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;"> text character varying(500)</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;"> );</span></span></div><div> </div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;">create or replace function set_c_arr() returns class_mapping[] as</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;">$$</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;">DECLARE</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;"> c_arr class_mapping[];</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;">BEGIN</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;"> FOR I IN 1..10 LOOP</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;"> c_arr[I] := ROW(I,I*10,'Test verisi');</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;"> END LOOP;</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;"> RETURN c_arr;</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;">END;</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;">$$</span></span></div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;">language plpgsql;</span></span></div><div> </div><div><span style="font-family:courier new,monospace;"><span style="background-color:#ffffff;">select * from unnest(set_c_arr());</span></span></div><div> </div><div><span style="font-family:arial,sans-serif;"><span style="background-color:#ffffff;">Yukarıdaki select sorgusunun çıktısı aşağıdaki gibi olacaktır.</span></span></div></div><div> </div><div><img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAATsAAADMCAIAAACDXpOFAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAcJElEQVR4nO3dfVwT9x0H8B8grQESEJAiEx+RIsJ0ikEEKrW8itswvnxYpEwdBMFAsUWnVoFpRSw+IMP5QHBomYooVYGrpUhtp3sNLA+KCqgFVgdKS1FAxdQMCuyPo1l2+eXIwwVy5Pv+w63n5e6TCz8vd/nwC0IAAAAAAAAAAPRg8uTJ27ZtG+4UTFJ+Rtu2bZs2bRplNexC9iEIYtWqVar+1tLSkiCIpKSk3NxcBvdIotkvDX9//+zsbAsLCzXXP3/+vIeHx6CrTZw4cefOnTk5OWQ2LYIZFFVHyc7O7vTp097e3gxuc3hhn9H8+fNzc3PHjh076EIGmeppuxp57bXXEEJmZmatra1MbVMgEAgEAq0fbm9vb2tra2JiMuiacXFxvr6+UqnU3t7+ww8/tLa2pll506ZNFhYW77//vo7xDISqoyQWixsbG8vLyxnc5vDCPqOysrLGxsaYmJhBFzJoFPk/CxYsCA0NdXR0NDExUfxJIs8DMpns1q1baWlpMpmMIIji4mJ/f/9z586FhITs2rWrrq6Ow+GsW7eO/MEtKSk5c+YMQsjKyioqKmrOnDlmZmY0CeSnGk9PT/I/aX6UsTmxe8fCrmlubh4SErJgwYKxY8eSm5VHIs/59EPr8OHDGzZsGDNmzO9+97udO3c+e/aMZuUJEyZ88sknT548UXz6+fn5kydPdnNze/jwYXJycmdnp5WVVXR09OzZs6VS6YULFz7//HNyTeUjj90LQRB5eXmnT59W/P8EQRQUFLi7u0+ePPn+/fu7d+/+8ccfsQuxR0n5yKs6So6Ojt7e3nv27FGMpOYLp9GRV37haFbG/iQrH3nsQuwzIl2+fHnLli1OTk7fffcdzcLdu3fb2dlt2LDh5cuXNCHVMTBio6OjKyoqYmJient7Ff+aPArOzs5HjhwJDAy8dOkSQsjW1tbS0tLDw8PCwsLT07Ourk4kEjk4OISFhU2aNCklJaWhoaGyslIkEnl6em7evFkqlZ46dUrxwCluXyAQBAcHh4aGvnjx4saNG5mZmTRxsTmxe8c+HLvm6tWrf/Ob3+zZs6e6uprcrEAgWLp0aXh4+DvvvCOVSumPYGxs7Ndff/3LX/7y4sWLYrE4PT39+fPnyqvJn7hQKBQKhUjhx3Hu3Lmpqam9vb2HDh0KCAjIz89fu3atq6trbGysr6+vWCxuaGhobGzEHnn6bBSBgYEffvihqanpvn37AgICioqKsAuxR0n5yKs6SrNmzUII3bt3T3HXar5wGh155ReOBvYnWfnIYxdinxHp7t27CCFPT0/FEau80MTEhKl3DQMj9tatW/Pmzevo6CguLpa/NZ0+fXpkZOTEiRPNzc0RQjY2NuTy5uZmPp9P/jlq1CiEkI+PD4/Hk1+FTpkypbKy0svLq7S0VPGZIBX/ajo6OnZ0dDg5OQ36rhibE7t37MOxay5YsODatWtVVVX0u1YlPT0dIRQXF9fW1paUlKRqNfl5SX72kysrK/v222+RwsHx8vK6du1ae3v7lStX1q5d6+HhQY5Y5SOvkeLi4vr6evJHZ8yYMaoWYo8S9shjkdcFlH+2dHzhsNR/4VT9JCsfeexC7DMikQvlG1S1MD4+Xv3nRW/gVd+7dy+fz1+8eHFGRsb27dtramoQQuRJPCwsrKurS/Hc2NfXJ/+TZGZmVlRUJJFIFDfN4XB6enoQQoo/W8rnWMUlERERERERNG9vsDmxe8fCrmlubv7TTz8N+lh6y5cv13ELikxN/+/+AnkYEe7Iq0KOQMp2yAf29/fLV8AuxB4l7JHHIq8LeDxeZ2cn/cPVf+Gw1H/hVP0kqwn7jEhcLhch9PTp00EXMmXgFe3v7y8vL5dIJGZmZvJ701wuVyqV9vX1ke/iaNTV1fn5+U2bNk3x1P/gwYOZM2dyuVzKWylF5JKGhoZHjx4hhDZt2kR/NYLNid27+jmrq6v9/f3d3d0Vf77JfyZff/11+g3qSW1trZeX15gxY95+++3e3t7q6mqNHt7Z2Tl16lQOhxMdHa3F3rFHCXvksUeptrYWIeTu7q64UP0XTv0jj33hsNT/ScbCPiOSm5sbmYR+YVpa2okTJ5ycnLTYO8XA2Y/8h6e7u7uiouKLL74gF2ZnZ69evTojI+PatWuPHz+m2YpEIhGLxUlJSZaWlujntxNZWVmbNm2SSCR5eXnff/89zcPHjRv34sULhBD9aqpyYvdOuW4kF2LXlEgkERERW7duJd/GkAvLysrefPPNxMTEUaNGDf1N3WPHjsXGxmZmZra3t6emplKuLAZ18uTJ8PDw48ePf/bZZ21tbZruneZ4Uo489ig9evTo5s2bixYtKi0tlW9T/RdO/SOPfeGw1P9JxsI+I1JQUND169cpB1l5oUwms7e3p1zuAmAoHBwczp49O3/+/OEOwhjsM/L29s7JybGzs6NfOHr06A8++OD8+fO/+MUvdE9iWJ96gRHD1dV1+fLlKSkpum8Ke+WJPaOqv6YWlJ9RfHz8+fPn6+vrFVdTXpibm/vgwYOcnBxN7+0PD/rPVw0cq8ODEWnwztNHH3107NgxDoczBGkAAPR0ailq3dpVZzs6FoPZQscarWG2cIH+DP4pPIMf/mqEcst3pNKxRmuYLVygP3QjVj5aFGs6araFtfPGG2/88Y9/vHDhwsmTJ+lTKRZEsZ1VHRvIQ0NVjRabc/369WZmZunp6VFRUa+88srhw4c1auECY0F5X/ree+99/PHHTk5O1tbW6rxlVefmDbkdT0/PixcvRkZG0uxdztnZmSCI4OBghNDZs2c3btxI+RcEu/Ddd9/96KOPLC0tZ8yYQRDE3LlzdQ+vo6VLlxIEQX4gKYfN+corr6Slpa1YsSI1NZVs26l6OBjBNO6mYtvCupswYUJwcPDVq1ezsrJoVsMWRLGdVX0UWYcMNmd3d3dBQcG7774rkUjkvUVgbDQesdi2sO5kMllPT4+VlRX9atiCKLazqo8i65DB5rS3t1+xYsXGjRvj4+Pr6uq0KDOBEUDje8XYtrDu2tra9uzZM3fu3KioKJrVsAVRbGdVxwbykMHWaJVzmpubb926NTc3t6Wl5cyZM1u3biXfZQxv/xkMPboRK5/ZRCgUyk9oWVlZHA5HIpE0NTUNWgPWSF1d3bFjx37729+SvweD3Xt2dvaECRMyMjK4XK68IEqumZ6erthZxS6USCT3799PSkoqLCw0kLvQZWVld+7cSUxMVMyjnHPdunU//PDD9evXEUKlpaVtbW1isVjVwwHQHqtrQ6wOD0Ykg5jnCQAAAAAAAAAAAACMQMx3gyl27dr15MkTln7cz+rwYESCe8UAsMn/qj+KH8HLP4TUZSHlM33FWeqZ3RGEH8aFYKRh9a+kszo8GJHgXTEAAAAAAAAAADbR++exBEFIpdJvvvlG3zvSB1aHByMS3HkyLurPPg3zVBsmjWd+cXNzW7JkiY+Pz9WrV8mvTjVMqnIuW7YsODjYysrqX//61/Hjx8nvZdWFqk9u1eTv7x8RERETE/Pjjz/qmAQYA41H7IoVK0pKSnx9ffWRhkHYnAEBAWvWrElJSampqRGJRDt27IiMjJTJZLrsiOarnNUxxBMOqz/79HDNUw3oaTxik5OT9ZGDcdicwcHBd+7cKS8vHz16tIODg7W1tZeX1z//+U/G946dcFh5CmX1Jxzm8/mrV69ev349+Z9paWm5ubmVlZXYHREEkZ+fP3nyZDc3t4cPHyYnJ3d2dmJnn8bO6oxdExgI47qOHT9+fHNzs5WVVVJS0s2bNxFCjHxBoDKRSOTg4BAWFrZ///6QkBBywuHo6Ohvvvlm2bJl8rEhEAg+/vhjhNA777xD3/urqqqytLQk0zo6OvJ4vKqqKlU7QgjNnTs3Ozt78+bN06ZNCwgIQD9/1zZls8qRVK0JDASTM5gaPnNzcwsLi+Tk5IKCgq+//lokEnV3d+tjR9gJh7FTKKupr6/vypUrvr6+eXl5fn5+X3zxRX9/v6odIYTKysq+/fZbNFgBWJdIYFgY1zm2tbX1jTfeOHPmzNWrV8ePH48Qamlp0ceOyAmHBT87d+4cQmjv3r0HDhxwcXHJyMjw9PTUdJslJSU+Pj4IoXnz5pWUlNDsSH06RgJDz7hG7JdfftnT09Pe3s7lcletWtXa2nrjxg197Ag7MTJ2CmX1Jxx+8uRJZ2fn7NmzHz9+3NnZSbMj9WEjAUOm8bti+W2JhQsXLly40GAveLA5CwoKeDxefHy8tbX1vXv3EhMTGZwkXZFEIhGLxUlJSeQ34ijeZ+ru7lacQrmsrOzNN99MTEwcNWrUoAfz8uXL69atO3r0KP2OsOQHRCgUCoVCmkjYNYGxYPWUv6wOD0Yk43pXDADbwYgFgE1gxBoX6BWznTa94piYGCcnp+bm5sOHD5Mf+hkgVTmhVwyMy6ZNmyZNmmRnZ/fXv/714MGDg64/XDdvsDkDAgIKCgq8vb0tLCxiY2NPnTo1evRomo2oH17rGaHgS9aBRjQ+x6amppL/p76+ns/nM52HMdic0CtG0CtmOS2vY1999VV3d/f79+8zm4ZxlJzQK6ZsFnrFrKNNr9jExCQ2NpbL5WZlZTEeiEHKOaFXTAG9YtbR5hwbHh7u7++/f//+pqYmxgMxSDkn9IopoFfMOhqP2JUrVy5ZsuTQoUPl5eX6CMQUbE7oFVNAr5h1NH6ZKR9mDHrBQxBEVlYW5VFDAJvT1NR0zZo1/v7+ZK/40KFD9N+CpX54yhwU9vb2YrF4xowZ2F7xrVu3Dh482NXVhRDicDgJCQnu7u7q9Iq9vb1FItHRo0dv375NvyPlm0bYA4KNpOlLDEYUVldzWR0ejEjQeQKATWDEAsAmMGKNC/SK2U7L32iXyWSPHj3KycnR071W3anKCb1iYIx4PN7OnTtzcnIGXXN4b95QckKvGLCdlnMpmpqavvrqqw0NDcymYRwlJ/SKEfSKWU6b61iCIE6ePOns7Pzpp58yHohByjmhV0zZLPSKWUebc6xAIOByuQKBYPv27QkJCbW1tYzHYoRyTugVU0CvmHW0vFfc1dWVn59vYmLi4uLCbCBmUXJCr5gCesWso82INTExsbGxWblyZW9vb3V1NeOZmKKcE3rFFNArZh0tP915+fJlfX19YmKiwf76DjYnzFeMYL5iQI/V1VxWhwcjEnSeAGATGLEAsAmMWOMCvWK20+bzWFNT05SUlOnTpxt4JwabE3rFgNW0GbErV65saWmZPn0642mYpZwzICBgzZo1KSkpNTU1IpFox44dkZGRMplMl73QTPugDnt7e1tbW+0+m9FCfHw842uCoaTNdwL4+Phs3rw5MDBQH4GYgs0JvWIEvWKW0+w6lvyVl9TU1P/85z96CsQIVTmhV0zZLPSKWUezc6xYLC4sLGxubtZTGqaoygm9YgroFbOOZufYgICA9evXEwRBvnESCoX6SaUrVTmhV0wBvWLW0WzEChQghPLy8vSTSleqckKvmAJ6xayj5W+0sxT0ihH0igE9VldzWR0ejEjQeQKATWDEAsAmMGKNC/SK2U7L32iXM9jLPFU5oVcMjIumN2OG6+YNdr8wXzFgO+P6dAd6xQh6xSynzXXs2rVrL1y4kJGRIRQKh+yXTrSgnBN6xZTNQq+YdTQ+xwoEAhMTEy6X++tf/3rVqlUymWzov81ZHdic0CumgF4x62hzju3v73/+/Dk50b6TkxPTkRijnBN6xRTQK2YdLT/dsbW1DQsL6+7u/uqrr5gNxCxKTugVU0CvmHW0/HTn2bNn9fX1CQkJ9fX1ekjFAGxO6BUj6BUDeqyu5rI6PBiRoPMEAJvAiAWATWDEGhfoFbOdNp0nd3d3oVDo4uLC4/EM+TIPmxN6xcC4uLm5Xbx48fe//72dnZ066w/XzRtsTugVA7bT+BwrFArv3r2bk5OjjzQMwuaEXjGCXjHLaXwd+/rrr3d0dOzbt+/cuXNxcXFmZmb6iKU7bE7oFVM2C71i1tH4HGtpaTlt2rQdO3ZMnTp127ZtN2/e/Mc//qGPZDrC5oReMQX0illH4xErlUqrqqra2tqePn2KEBo7dqweUjEAm5PsFe/bt6+iosLFxQXpuVcskUgUF+7du5fP5y9evDgjI2P79u01NTUabbOkpCQhISEvL2/evHm7d++m2ZH6dIwEhp7G74rLy8t/9atfcblcPz+//v5+g32NsTmhV0wBvWLW0fgc+7e//e299947fvx4Z2fnwYMHDbZXjM0JvWIEvWJAj9XVXFaHByMSdJ4AYBMYsQCwCYxY4wK9YraD+YqhVwyMw8yZM/fv3z/oasN+80YxJ/SKAdtpP1/x8uXLCwoKGIyiJ4o5oVeMoFfMclpex06ZMsXJyen69evMpmEcJSf0iimbhV4x62h5jl22bNmlS5f6+vqYTcM4Sk7oFVNAr5h1tDnHOjg4zJkzRz5lrsFSzgnzFVPAfMWso82IXbp06VdffWX49zaVc0KvmAJ6xayj8btiLpe7cOHC999/Xx9pGITNCb1iBL1iQG/YP93RBavDgxEJOk8AsAmMWADYBEascYFeMdtpfOfJy8vrD3/4w7hx4zo6Os6ePWuw322nKif0ioFxOX369MaNGy0tLbds2XL27NlB1x+umzfYnNArBmyn8Tn24cOHU6dOtbOzmzhxYm1trT4yMQKbE3rFCHrFLKfxdWxycrKpqenhw4dHjx6t9RR+QwCbE3rFlM1Cr5h1NB6xQqFw7Nixf/rTn+rq6v785z+TXT8DhM0p7xUXFRUVFxcjhPTXK/bw8MjNzU1JSUEITZkyBf1c4l29erWjo6OmG5T3ihFClF6x8o7Qz73ipqYmgUCQn5+varO6RALDQuMRGxQUVFVVdfv27WPHjllbWy9atEgfsXSHzQm9YgroFbOOxiP2+fPnzs7OPB6PrKH+8MMPekjFAGxO6BVTQK+YdTS+87R///7IyMjjx4+/fPmyoKDgs88+00cs3WFzQq8YQa8Y0GN1NZfV4cGIBJ0nANgERiwAbAIj1rhAr5jtNL7zZGNjIxaLZ82a9ezZs9zc3KtXr+ohFQNU5YReMTAuCQkJf/nLX3g8XlBQUH5+voODA/36w3XzBpsTesWA7TR+Vzxz5szq6urnz59fu3bNzMxszpw5+oilO2xOea+4r69P3ivWx945HE5cXNwnn3ySnZ0dGhpKLlywYEFmZmZhYaH8tEwQRHh4OEIoNzeXcq6m4PP5hw4dkv9nWloaWUjE7ojcbFJSUl5e3oEDB8aMGUMuJCn+y6IcSdWawEBoPGIfP348ffp0CwuLoKAghJCNjY0eUjEAmxN6xZTNQq+YdTQesRKJxMbG5sSJE+T7SalUqodUDMDmhF4xBfSKWUfjEVtTUxMVFRUSEnLnzh2E0N27d/WQigHYnNArpoBeMeto8+kOl8vl8/kbNmwoLS3V/V6r/ijnhF4xBfSKWUebb6OUyWQtLS1FRUWffvqpPjIxApsTesUIesWAHquruawOD0Yk6DwBwCYwYgFgExixxgV6xWxHd+fJzc1tyZIlPj4+V69eTU9Ply9nvJqrI41yQq8YjFiJiYl8Pp8giLi4OPlC/VVzhyAn9IoB29GdY5OTk5UXDtmUv+pTPyfMV4xgvmKW0/g6dsiquTrC5oReMWWz0CtmHY1H7JBVc3WEzQm9YgroFbOOxiN2yKq5OsLmhF4xBfSKWUfjETtk1VwdYXNCr5gCesWsQ/cyUz63IK9tTE1N16xZ4+/vT1ZzDx061NbWRr+RrKws+l/X1pH6OfUXniAIxfs09vb2YrF4xowZ2F7xrVu3Dh482NXVhRDicDgJCQnu7u7q9Iq9vb1FItHRo0dv375NvyPlm0bYo4SNhF0TGAtWV3NZHR6MSNB5AgAAAIbA5MmTt23bNtwpBrFt2za4RwIAsrOzO336tLe3t3yJm5vbBx98UFBQoNj+QwgtW7bsxIkTeXl5KSkpLi4uQ5xz/vz5ubm5Y8eOHeL9AmAI/ncdKxaLGxsby8vL5UtWrFjx97//3dT0/651AwIC1qxZk5mZGRYW1tLSsmPHDvpqLuPKysoaGxtjYmKGcqcAGIiBXrGjo6O3t/eePXsU/07HXjG23WplZRUdHT179mypVHrhwoXPP/88KCjIxcXlyJEj5KNCQ0O7u7vPnz+PrbySLl++vGXLFicnp++++46ZwwAASwycP2fNmoUQunfv3qAP0Kiaq9xuXbt2raura2xsLEEQYrHYxcWloaGBvC7Nzs62sbH56aefXr58iVRUXknkxIjQ0QFGaGDEWltbo5/7N/Q0quYqt1u9vLwqKira29uvXLliYmLi4eHR1NTk6OhoYWHx5MmTwMDAnp4emUyGaCuvZE6DndwcAP0ZGLHPnj1DCPF4vEEfoGM1l3JV3NPT09vb29zczOfzCwsL/fz85OdYmsorl8tFCD19+lT9/QIwMgyMn9raWoSQu7v7oA/QsZpbW1vr5eU1ZsyYt99+u7e3t7q6GiHU0NDw1ltv/fvf/25sbJw3bx45Ymkqr25ubggh8rEAGJWBO0+PHj26efPmokWLSktL5X8n75cuXLhw4cKF5PWkjlP+Hjt2LDY2NjMzs729PTU1lbx11NDQEBwc3NraeuXKlX379p06dQqpmEqXFBQUdP36dfpKMAAjnIODw9mzZ+fPnz/cQQbh7e2dk5NjZ2c33EEAGG6urq6G33mKj493dXUd7hQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADEabr1caLtjvv4Fv2QBGZYi+xYMgiFWrVqn6W0tLS4IgkpKSyK8qBwCoYhDfu/Paa68hhMzMzFpbW4c7CwAGbWDWGFWTA5NvRGUy2a1bt9LS0mQyGUEQxcXF/v7+586dCwkJ2bVrV11dHYfDWbduna+vr1QqLSkpOXPmDELIysoqKipqzpw5ZmZmNAnk73XJ6dfg6+QAoDEwYqOjoysqKmJiYiiTNpGDx9nZ+ciRI4GBgZcuXUII2draWlpaenh4WFhYeHp61tXViUQiBweHsLCwSZMmpaSkNDQ0VFZWikQiT0/PzZs3S6VScuomhPtuUoFAEBwcHBoa+uLFixs3bmRmZg7F8waAnQZGLDk5cEdHR3Fxsfyt6fTp0yMjIydOnGhubo4U5gcmJysl/xw1ahRCyMfHh8fjya9Cp0yZUllZ6eXlVVpaSpm2H3v+dHR07OjocHJygnfFANAbGLF79+7l8/mLFy/OyMjYvn17TU0NQmjDhg0vX74MCwvr6upSPDf29fXJ/ySZmZkVFRVJJBLFTXM4nJ6eHoQQOapJyudYxSURERERERHwrhgAVQbGEjk5cEtLy9GjR6dNm0aOWC6X++TJk76+PqFQSL+Vuro6Pz+/L7/8srGxsb+/n1z44MGDmTNncrnc8PBw+Ztt5dEoEAgOHDjA4XDGjx+/adOm+vp6Jp8fACPLwL1igiAIgkhPT1ecHDg7O3vChAkZGRlcLvfx48c0W5FIJPfv309KSiosLJSfM7OysjgcjkQiaWpq+v7772kePm7cOPI8TL8aAAAaFACwiUF8HgsAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIAR6L8GnuOFjJpN3AAAAABJRU5ErkJggg==" /></div><div> </div><div>İyi çalışmalar.</div><div>Samed YILDIRIM</div><div> </div><div> </div><div> </div><div>29.12.2016, 12:42, "Cem Kücük" <bcemkucuk(at)gmail(dot)com>:</div><blockquote type="cite"><div><div><div><code>Selam arkadaslar,</code><br /> </div><code>asagidaki oracle dan migrate edilmis iki custom tip var..</code><br /> </div><code>oracle<br />--------------</code><br /><code>create or replace<br />TYPE CLASS_MAPPING_TAB IS TABLE OF class_mapping;<br /><br />create or replace<br />TYPE CLASS_MAPPING IS OBJECT (<br /> ID NUMBER,<br /> klasse NUMBER,<br /> text VARCHAR2 (500 CHAR)<br />);</code><div><br /> </div><div><code>postgres:</code></div><div><div><div><code>--------------------------<br />TYPE class_mapping_tab AS<br /> class_mapping_tab class_mapping[];<br /> <br />TYPE CLASS_MAPPING IS OBJECT (<br /> ID NUMBER,<br /> klasse NUMBER,<br /> text VARCHAR2 (500 CHAR)<br />);<br /><br />Sizce bu ne kadar dogru bir konvert ?</code><br /><br /><code><code>class_mapping_tab nasil set edebilirim ?</code></code></div><div> </div><div>asagidaki gibi olmadi</div><div><code><code>..<br /> tmpval RECORD;<br /> retval class_mapping_tab;<br /> retval := array[ ROW(tmpval.ID, tmpval.klasse, tmpval.text) :: class_mapping)]; <br />..</code></code><br /> </div><div><code>saygilar,</code></div><div><code>kuecuek</code></div></div></div></div></blockquote>