What is the proper Syntax of SELECT INTO in Postgres?

Question

I'm converting an app from MySQL to Postgres and some triggers need to meticulously converted.

In MySQL the triggers access data from another table to update data in the current table and the syntax is:

SELECT first_name, last_name INTO v_instructorfname, v_instructorlname from instructors WHERE objid = NEW.instructor_id;

I'm not as proficient with Postgres so I'd like to determine the proper syntax to execute this same line of code in Postgres. I've been searching Google for about 30 minutes without finding a relevant answer.

Would appreciate some tips on the syntax that works.

Does this answer your question? [SELECT INTO with more than one attribution](https://stackoverflow.com/questions/16311634/select-into-with-more-than-one-attribution) — Mike Organek, Mar 30 '21 at 22:42

score -1 · Answer 1 · answered Mar 30 '21 at 22:42

-1

What about:

SELECT first_name AS v_instructorfname, last_name AS v_instructorlname FROM instructors ...

answered Mar 30 '21 at 22:42

user3832673

369
2
7

What is the proper Syntax of SELECT INTO in Postgres?

1 Answers1