Is there a straightforward way to adapt these types of MySQL queries to PostgreSQL:

1. setting variables in MySQL like

        set @aintconst = -333
        set @arealconst = -9.999

 [It seems not](https://stackoverflow.com/questions/13316773/is-there-a-way-to-define-a-named-constant-in-a-postgresql-query).

2. 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).