How to put a select into an integer with POSTGRESQL

Question

I want to put this request (SELECT qte FROM table_stock where id_pro = cpt1) into an integer, like that i will be able to check if the product still exist (if quantity >0) so I us

Oleg Levin · Accepted Answer · 2021-07-15 20:04:11Z

1

SELECT qte 
   into quantite 
FROM table_stock 
where id_pro = cpt1;

More details in the PL/pgSQL reference

edited Jul 15, 2021 at 20:04

user330315

answered Jul 12, 2021 at 18:33

Oleg Levin

3,6291 gold badge10 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Frank N Stein · Accepted Answer · 2021-07-12 19:13:37Z

1

Try to avoid the loop with a single query like insert into table_result select... where quantity > 0;

answered Jul 12, 2021 at 19:13

Frank N Stein

2,5983 gold badges24 silver badges30 bronze badges

Collectives™ on Stack Overflow

How to put a select into an integer with POSTGRESQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related