Re: [SQL] passing array(java) to postgre sql function

2006-02-22 Thread Markus Schaber
Hi, Bond, bond wrote: > public Object getArray(){ > ArrayList temp = new ArrayList(); > temp.add(""); > temp.add(""); > temp.add("T"); > temp.add("Q"); > return temp.toArray(); > } > After this i am passing this.getArray() values to database. As a firs

[SQL] passing array(java) to postgre sql function

2006-02-17 Thread bond
Hi All, in postgreSql, i have written a function which accepts a String array and inserts the contents to DB. when i tested that function by passing the values like: SELECT TEST_ARRAY('{xxx,,,ww}'); where TEST_ARRAY is my function name. the records get inserted correctly. But now th