POSTGRES Joining a function in a View

Question

I am writing a postgres query which is a view. I have another stored function (functionsalary) in the databse. What i want to do is this:

 Create View salaries as
 Select name,
        employeeid,
        functionsalary.totalsalary
 from tblemployees
 JOIN functionsalary 
on employees.employeeid = functionsalary.employeeid

However when i try to run the same i keep getting the error saying 'functionsalary' does not exist. Even though i have checked that i can run the function independently and that it does output data. Is there a reason this is happenning. I'm Using POSTGRES(9.3). Thanks in advance.

klin · Accepted Answer · 2016-02-05 02:29:13Z

1

Postgres has to know whether functionsalary is a table or a function. You should put the arguments list (maybe empty) of the function:

...
JOIN functionsalary() 
...

edited Feb 5, 2016 at 2:29

answered Feb 5, 2016 at 2:14

klin

123k15 gold badges240 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ang Over a year ago

Thanks so much... I didn't know that. Works now.

Collectives™ on Stack Overflow

POSTGRES Joining a function in a View

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related