simple postgres syntax issue

Question

I am new to postgres from sql server. I have written a function getSkill that takes an integer and returns a type "Skills" from the "Skills" table. Now I want to feed it "SkillIDs" of type integer from the "Jobs" table. If I do this, then postres says there is a syntax error and puts a little caret at ^getSkill.

select * from getSkill(select "SkillID" from "Jobs" where "JobID"="posID") //syntax error at ^getSkill

I am pretty sure the statement in the () is a valid postgres statement--but if I replace it with an integer the sytnax error goes away.

select * from getSkill("0") //returns an error saying there is no row at position 0 in the DB, because it is still unfilled2

This is confusing for me. The syntax error seems to go away if I replace a valid postres statement returning an integer with a simple integer.

Can somebody explain what's up?

Arun P Johny · Accepted Answer · 2013-03-27 04:58:59Z

1

I think it should be

select getSkill(SkillID) from Jobs where JobID="posID"

answered Mar 27, 2013 at 4:58

Arun P Johny

389k68 gold badges532 silver badges532 bronze badges

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

Collectives™ on Stack Overflow

simple postgres syntax issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related