I'm moving databases from sybase to postgres. But I have difficulties in creating a postgres equivalent to the sybase stored procedures...
Apparently, Postgres functions should work, but the syb stored procedures get only one parameter and return several colums
Here's the code I wrote in postgresql :
create function function_name( int ) returns text AS ' SELECT column1, column2, column3,...,column15 FROM table_name WHERE colum1 = $1 AND column5 = \'specific value\' AND column8 = \'specific_value2 \' ' LANGUAGE 'SQL';
and I get the message error : returns multi columns
I'm wondering too if It's possible to create a view with a parameter if functions don't work.