Use result of select in variable

[Leandrobugalho]

Can i use the result of select in a variable?

@set a = select nome from table1 where cod=1
select * from table where name where = :a

Database: postgresql

[E1izabeth]

There is no such possibility.