Hello Stack Overflow Exchange People

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.

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

Thanks

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.

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

Hello Stack Overflow Exchange People

Is there a straightforward way to adapt these types of mySQL queries to postgreSQL:

a) 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

b) 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 b)

Thanks

Hello Stack Overflow Exchange People

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.

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

Thanks

Hello Stack Overflow People

Is there a straightforward way to adapt these types of mySQL queries to postgreSQL:

a) 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

b) 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 b)

Thanks

Hello Stack Overflow Exchange People

Is there a straightforward way to adapt these types of mySQL queries to postgreSQL:

a) 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

b) 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 b)

Thanks