Variables in Aster


Variables in Aster

I’m trying to find out if there are variables in Aster SQL… there are in postgres but it seems this is not supported in Aster?

I’d need something like

Declare x bigint := 100;

Select * from my_table where y>x;

Alternative is to store the value in a tiny table, but maybe there is a nicer option?

What if we’d need to re-run same large chunks of codes for a few variable values? Is there something like a loop? Or again some workaround with an extra tables and joins on it…?

Thank you very much!


Tags (1)