Re: [SQL] How to return records from a function

2003-02-02 Thread John Cavacas
I guess I can just use a regular statement calling a function but there seems to be problems doing that as well. Are there any other JDBC drivers for PostgreSQL? Thanks, john - Original Message - From: <[EMAIL PROTECTED]> To: "John Cavacas" <[EMAIL PROTECTED]> Cc: &l

[SQL] How to return records from a function

2003-02-02 Thread John Cavacas
Hello everyone. I've spent the last few hours trying to come up with a function that at the most basic returns the result of a SELECT * FROM . This is easy to do in something like MSSQL or Oracle. For example in MSSQL i can do something like: CREATE PROCEDURE proc_name AS BEGIN SELECT * FROM s