dbTalk Databases Forums  

help on function - result set

comp.databases.postgresql.questions comp.databases.postgresql.questions


Discuss help on function - result set in the comp.databases.postgresql.questions forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
 
Posts: n/a

Default 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.





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.