help on function - result set -
06-09-2005
, 12:01 PM
I've got a little issue - when I run for example "SELECT * FROM test" my
result is:
id name
1 first test
2 second test
but when I create function:
CREATE OR REPLACE FUNCTION sp_r()
RETURNS SETOF test AS
'select * from test
'
LANGUAGE 'sql' VOLATILE;
my result is:
Row sp_t(test)
1 (1, "first test")
2 (2, "second test")
and in my application it appears as:
sp_t
(1, "first test")
(2, "second test")
I think i once found some keyword to turn off the row numbers or to turn on
the descriptors so that the result was identical to the first statement, but
after spending quite a lot of time searching for it I just can't find it. |