What does the @ symbol signify in this sql expression?
update some_table set some_number=(@some_number+1) where some_id=1;
It seems to return the same result as:
update some_table set some_number=some_number+1 where some_id=1;
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityWhat does the @ symbol signify in this sql expression?
update some_table set some_number=(@some_number+1) where some_id=1;
It seems to return the same result as:
update some_table set some_number=some_number+1 where some_id=1;
@
is the "absolute value" operator.
SELECT @ -1;
?column?
----------
1
(1 row)
It returns the same value for positive numbers.