[SQL] restircting rows

    hi all, my query return 100 rows but if i am intrested only from 40-60 rows then how to restrict. for example select * from students (returns 100 rows).but i am intrested only rows from 40 to 60.

[SQL] passing array to database function

 hi everybody, i want to pass Integer array to database function from java precompiled statement. java gives java.sql.Array interface but i dont know which implementing class i have to use in postgre regards ptrashantha.k.p

[SQL]

    hi every body, how to return the resultset from the function

[SQL] handling money type

hello developers, i have facing one major problem handling sql money dataType in the java i have tried many permutation and combination but still i dint got correct data type to use in java to pass money data

[SQL] catching errors in function

  hello sql developers, i have written function in which while executing it may throw error. if the error thrown i want rollback the transaction if not i want commit. how can i achive this task. how can catch exception thrown in the function plz help me regards konkodi