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
