3

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;
  • 1
    Please tag your post. It is unclear which SQL language you are using. – Elaskanator Aug 15 '18 at 16:21
3

@ is the "absolute value" operator.

SELECT @ -1;
 ?column?
----------
        1
(1 row)

It returns the same value for positive numbers.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.