- Anasayfa
- Microsoft
- SQL Servers
- Postgresql de multi dimentional array den veri alma
Beyaz.Net İpucu
Postgresql de multi dimentional array den veri alma
deneme isimli array kolonumuz olsun ve icerigi {{10,20,30},{40.50,60}} olsun
select deneme[1:1] #1. arrayin 1. degerini dondurur. [2:3] -> 2. arrayin 3. degerini dondurur
from tablo
where x = 1
select deneme[1:1] #1. arrayin 1. degerini dondurur. [2:3] -> 2. arrayin 3. degerini dondurur
from tablo
where x = 1