postgresql- how to define a variable by a function call in an if statement [closed]

I have this function:

CREATE OR REPLACE FUNCTION findMyList( p_user_id bigint)
 .... 

DECLARE

   myVar_id bigint;

...

      IF myVar_id = select p_user_id from myFunction(p_user_id )  THEN
       NULL;
     ELSE
       myVar_id := NULL;
     END IF;

​x
 
CREATE OR REPLACE FUNCTION findMyList( p_user_id bigint) .... ​DECLARE​   myVar_id bigint;​...​      IF myVar_id = select p_user_id from myFunction(p_user_id )  THEN       NULL;     ELSE       myVar_id := NULL;     END IF;​

however there appears to be a syntax issue that I can’t work out why it does not allow this as it doesnt seem unreasonable:

ERROR:  syntax error at or near "select"
LINE 78:      IF myVar_id = select p_user_id from myFunction...

 
ERROR:  syntax error at or near "select"LINE 78:      IF myVar_id = select p_user_id from myFunction...​

why does it not let me define the variable as such?

Answer

Try :

myVar_id := (SELECT p_user_id from myFunction(p_user_id))

 
myVar_id := (SELECT p_user_id from myFunction(p_user_id))​

Advertisement

Answer