Hi Oliveiros, Thanks for your reply and I am sorry I didn't notice that I missed pgsql email id.
Yes, the solution that you stated is what I am going to do. First query to get the number of elements in the array, then fetch the elements by building a query. I am also using C# and I guess this may be the solution to my problem.
.Do you need to retrieve all the arrays in that column in just one query?
Or just need to get one with a particular ID?
I learned bout the existence of arrays a few days ago :-)
If I had this problem and with my current knowledge on arrays I would issue first one query to obtain the dimension and then programmatically I would build the next query with the exact number of columns (I use C# for client programs).
It would work fine if you are just hunting for a particular record on your table, but I don't know if that's your goal....
Also, Please don't send private replies, always include the mailing list address
because someone with more knowledge than me might be able to quickly help you ;-)
Hi All, I have an array column in a table. How can I fetch the elements separately( ie, select arr[1],arr[2]...arr[n]) as a column, when I don't know how many elements are there in the array?
