Hi:
At the PSQL prompt, I want to set some variables based upon query results, or via static assignment, then insert a record with those values. Sort of like...
select val1 into x from agedata where name = ‘joe_mako’;
select val12 into y from sizedata where name = ‘joe_mako’;
thename := ‘joe_mako’;
insert into newtable (name, age, height) values (thename,x,y);
Some sort of compound insert statement would solve my problem, but in a larger sense, how do you (can you ) do something like this inside a statement blocks of some kind? I’ve done some PL-pgsql and know about statement blocks in that context. But I don’t want to have to create a function, use it, then delete it. Was wondering of something else could be done.
Thanks
-dave