By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,105 Members | 2,560 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,105 IT Pros & Developers. It's quick & easy.

help on function - result set

P: n/a
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.


Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.