Hello this is feature. Record needs two and more fields. So when is only one out variable, then result must be scalar, etc -- setof float4. regards Pavel Stehule it's little bit simple in 8.4, there you can define create or replace function test.test() returns table(_rank float4) as $$ 2008/12/24 Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx>: > I was doing some test to track down an error in a more > complicated function and I stumbled in this behaviour I can't > understand: > > create or replace function test.test(out _rank float4) returns setof > record as $$ > begin > return query select 1::float4; > return; > end; > $$ language plpgsql stable; > > and I get > > ERROR: function result type must be real because of OUT parameters > > > ********** Error ********** > > ERROR: function result type must be real because of OUT parameters > SQL state: 42P13 > > same with text etc... > > -- > Ivan Sergio Borgonovo > http://www.webthatworks.it > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
