Re: [SQL] returning composite types.

2003-03-29 Thread Franco Bruno Borghesi
yes, i was trying to do something like that, but it breaks always in the same place, first I thought that it was because of the way I was assigning values to the fields of my row, but now I'm beginning to think that the reason is the way I pass the row to f2. Here is the error: franco=# SELECT

Re: [SQL] Stored procedures

2003-03-29 Thread Franco Bruno Borghesi
As far as I know, you always work with a ResultSet. If you know your stored procedures will always return an Integer and you don't wanna deal with the executeQuery and stuff every time, you could create a class with methods explicitly for accesing your stored procedures, for example: assuming