patternsqlMinor
What does @ signify in a query expression?
Viewed 0 times
expressionwhatquerydoessignify
Problem
What does the @ symbol signify in this sql expression?
It seems to return the same result as:
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;Solution
@ is the "absolute value" operator.SELECT @ -1;
?column?
----------
1
(1 row)It returns the same value for positive numbers.
Code Snippets
SELECT @ -1;
?column?
----------
1
(1 row)Context
StackExchange Database Administrators Q#214999, answer score: 3
Revisions (0)
No revisions yet.