Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_jsp thread: how to get array from PostgreSQL


Message #1 by ngngachuen@i... on Thu, 1 Mar 2001 17:08:43
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

  Return to Index