[GENERAL] How to declare return type for a function returning several rows and columns?

2012-06-12 Thread Alexander Farber
Hello, I'm trying to create the following function which gives me a runtime error, because it obviously doesn't return a mere integer but several rows and columns (result of a join): # create or replace function pref_daily_misere() returns setof integer as $BODY$ begin create

Re: [GENERAL] How to declare return type for a function returning several rows and columns?

2012-06-12 Thread Dmitriy Igrishin
Hey Alexander, 2012/6/12 Alexander Farber alexander.far...@gmail.com Hello, I'm trying to create the following function which gives me a runtime error, because it obviously doesn't return a mere integer but several rows and columns (result of a join): # create or replace function