[SQL] postgres sql help

2011-10-16 Thread James Bond
hi, i am fairly new in postgresql, so if anyone can help me would be great if i simply do: select ver_no from version order by ver_no the result will be something like this: .1.3.1 .1.3.2.5. .1.4.1.7.12 .1.4.11.14.7. .1.4.3.109.1. .1.4.8.66. so as you can see first 3 lines ar

[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