HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

What does @ signify in a query expression?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
expressionwhatquerydoessignify

Problem

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;

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.