Hello everyone, I'm a brand new person to postgreSql, but not for databases. I came from Oracle and Sybase areas. I'm struggling to create a stored procedure. I searched on Internet for several hours trying to find a simple example, but didn't find anything. I saw dozens of questions how to create a procedure without any responses. I searched on postgreSql site and found a topic "Stored Procedure Example". But actually, they showed how to write a function on postgreSql database. I understand that sometimes it's possible to use a function instead of a SP and vice versa, but it's still different database objects. Can somebody show me an example of SP for postgreSql? It doesn't have to be complex, but it should be complete. I want to be able cut & paste into editor and compile it without errors. I would like to emphasize that I don't need an example for a function; I have tons of them but I don't have ANY stored procedure example. It would be great if you point me to a site with PostgreSql examples for different Stored Procedures if they actually exist as database objects on postgreSql database. Thank you, Vladimir
