hi all,
i am using PostgreSql in my project, i have a column "arrayColumn" that
is array and have the following values "{1,2,3.4}" and also have another
column "anOtherArrayColumn" that is also an array and that have no values
i.e. "{}" ,
now my question is how can i get the values from both column and how can
i check if the gotten values is empty or not i.e. "{}" ..
i only know how to write the following codes :
--------- code --------
myResultSet = stmt.executeQuery("select * from product where product_id
="+"'{"+"13"+"}'");
---end code -----
pls help me......
THX a lot
ngachuen