Is there a straightforward way to adapt these types of MySQL queries to PostgreSQL:
setting variables in MySQL like
set @aintconst = -333 set @arealconst = -9.999
Assigning variables from SELECT queries and using those variables subsequently in my SQL like:
select @pfID := id from platform where bios like '%INTEL%' select @clientID := id from client where platformID = @pfID
I'd be very grateful for pointers, especially on (2).