All Forums Aster
Robert Suhada 1 post Joined 06/14
01 Oct 2014
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!

Robert

You must sign in to leave a comment.