This page in other versions: Unsupported versions: 6.5

General Operators

The operators listed here are defined for a number of native data types, ranging from numeric types to data/time types.

Table 4-2. Postgres Operators

Operator Description Usage
< Less than? 1 < 2
<= Less than or equal to? 1 <= 2
<> Not equal? 1 <> 2
= Equal? 1 = 1
> Greater than? 2 > 1
>= Greater than or equal to? 2 >= 1
|| Concatenate strings 'Postgre' || 'SQL'
!!= NOT IN 3 !!= i
~~ LIKE 'scrappy,marc,hermit' ~~ '%scrappy%'
!~~ NOT LIKE 'bruce' !~~ '%al%'
~ Match (regex), case sensitive 'thomas' ~ '.*thomas.*'
~* Match (regex), case insensitive 'thomas' ~* '.*Thomas.*'
!~ Does not match (regex), case sensitive 'thomas' !~ '.*Thomas.*'
!~* Does not match (regex), case insensitive 'thomas' !~ '.*vadim.*'
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group