Re: [SQL] Returning data from multiple functions

2011-11-10 Thread Pavel Stehule
2011/11/10 tlund79 : > I know got this far thanks to Pavle Stehule. The function worked and returned > the data when the variables was predefined after "return query". > > When tried to replace these with variables passed through the function call > I got this message; > ERROR:  syntax error at or

Re: [SQL] Returning data from multiple functions

2011-11-10 Thread tlund79
I know got this far thanks to Pavle Stehule. The function worked and returned the data when the variables was predefined after "return query". When tried to replace these with variables passed through the function call I got this message; ERROR: syntax error at or near "RETURN" LINE 1: ...ll sele

[SQL] Returning data from multiple functions

2011-11-10 Thread tlund79
A short brief about the goal: I have a Excel workbook loaded with static data and need to compare these to "live-data" from DB. There are 20 rows with data in the report that needs to be retrieved from the database, and almost the same amount of queries, since all of these queries relies on variabl