Commits

Audrius Kažukauskas committed e6dfcb7

Tidy up and enhance pgsql.vim a bit.

  • Participants
  • Parent commits e55178b

Comments (0)

Files changed (1)

File syntax/pgsql.vim

 " Always ignore case
 syn case ignore
 
-" General keywords which don't fall into other categories
-syn keyword pgsqlKeyword  abort alter aggregate analyze as alias add asc
-syn keyword pgsqlKeyword  begin by before
-syn keyword pgsqlKeyword  conversion cascade current_date current_time current_timestamp class close
-syn keyword pgsqlKeyword  cluster checkpoint check comment commit
-syn keyword pgsqlKeyword  cast cascade character check column columns constraint create copy
-syn keyword pgsqlKeyword  database domain databases default delete drop declare deallocate desc
-syn keyword pgsqlKeyword  deferrable deferred defaults do diagnostics
-syn keyword pgsqlKeyword  explain end execute exclusion found exception except each exit
-syn keyword pgsqlKeyword  function foreign from full fetch force for
-syn keyword pgsqlKeyword  group grant global get
-syn keyword pgsqlKeyword  having
-syn keyword pgsqlKeyword  index into immutable inner initially immediate inherits instead insert if
-syn keyword pgsqlKeyword  join
-syn keyword pgsqlKeyword  key
-syn keyword pgsqlKeyword  language lock local limit left load loop
-syn keyword pgsqlKeyword  move match
-syn keyword pgsqlKeyword  notify no new next
-syn keyword pgsqlKeyword  operator outer order old on out open over
-syn keyword pgsqlKeyword  prepare plpgsql primary password primary privilege procedure partial prepared
-syn keyword pgsqlKeyword  partition preserve perform
-syn keyword pgsqlKeyword  role replace reindex release reset revoke rollback references row rows rule restrict
-syn keyword pgsqlKeyword  returns return recursive right
-syn keyword pgsqlKeyword  select set strict schema sequence savepoint simple system stable setof
-syn keyword pgsqlKeyword  truncate to tranaction trigger table tables temp temporary tablespace type
-syn keyword pgsqlKeyword  update unique unlisten using
-syn keyword pgsqlKeyword  verbose view values varying vacuum
-syn keyword pgsqlKeyword  where with
-syn keyword pgsqlKeyword  case when then else ifnull nullif
+syn keyword pgsqlKeyword abort alter aggregate analyse analyze as alias add asc
+syn keyword pgsqlKeyword all and any
+syn keyword pgsqlKeyword begin by before between binary
+syn keyword pgsqlKeyword conversion cascade current_date current_time cluster
+syn keyword pgsqlKeyword current_timestamp class close checkpoint check comment
+syn keyword pgsqlKeyword commit coalesce cast cascade character column columns
+syn keyword pgsqlKeyword constraint create copy case
+syn keyword pgsqlKeyword database domain databases default delete drop declare
+syn keyword pgsqlKeyword deallocate desc deferrable deferred defaults distinct
+syn keyword pgsqlKeyword do diagnostics
+syn keyword pgsqlKeyword explain end execute exclusion exception except each
+syn keyword pgsqlKeyword exit exists else
+syn keyword pgsqlKeyword function foreign from full fetch force for found
+syn keyword pgsqlKeyword group grant global get
+syn keyword pgsqlKeyword having
+syn keyword pgsqlKeyword index into immutable ifnull initially immediate insert
+syn keyword pgsqlKeyword intersect isnull ilike is in inherits instead if inner
+syn keyword pgsqlKeyword join
+syn keyword pgsqlKeyword key
+syn keyword pgsqlKeyword language lock local limit left load loop like lateral
+syn keyword pgsqlKeyword listen
+syn keyword pgsqlKeyword move match
+syn keyword pgsqlKeyword notify no new next not nullif
+syn keyword pgsqlKeyword operator outer order old on out open over overlaps or
+syn keyword pgsqlKeyword prepare primary password privilege procedure partial
+syn keyword pgsqlKeyword prepared partition preserve
+syn keyword pgsqlKeyword role replace reindex release reset revoke rollback
+syn keyword pgsqlKeyword references row rows rule restrict returns return right
+syn keyword pgsqlKeyword returning recursive
+syn keyword pgsqlKeyword select set strict schema sequence savepoint simple
+syn keyword pgsqlKeyword system stable setof
+syn keyword pgsqlKeyword truncate to tranaction trigger table tables temp type
+syn keyword pgsqlKeyword temporary tablespace then
+syn keyword pgsqlKeyword update unique unlisten using union
+syn keyword pgsqlKeyword verbose view values varying vacuum
+syn keyword pgsqlKeyword where with when
 
-syn keyword pgsqlTodo contained  TODO FIXME XXX DEBUG NOTE
+syn keyword pgsqlTodo contained TODO FIXME XXX DEBUG NOTE
 
 " Special values
 syn keyword pgsqlSpecial         false null true
 
 " Column types
 syn keyword pgsqlType            anyarray anyelement abstime anyenum
-syn keyword pgsqlType            anynonarray any aclitem bytea bit
+syn keyword pgsqlType            anynonarray aclitem bytea bit
 syn keyword pgsqlType            boolean bigint box cidr cstring char
 syn keyword pgsqlType            character cid circle double date
-syn keyword pgsqlType            gtsvector inet interval internal
+syn keyword pgsqlType            gtsvector hstore inet interval internal
 syn keyword pgsqlType            int2vector integer line lseg
 syn keyword pgsqlType            language_handler macaddr money numeric
 syn keyword pgsqlType            name opaque oidvector oid polygon point
 syn keyword pgsqlType            unknown uuid void varying
 syn keyword pgsqlType            xml xid float varchar decimal array
 
-syn keyword pgsqlOperator        between not and or is in like regexp rlike
-syn keyword pgsqlOperator        binary exists coalesce isnull ilike union
-syn keyword pgsqlOperator        intersect distinct
 
 " Define the default highlighting.
 " For version 5.7 and earlier: only when not done already
   HiLink pgsqlVariable  Identifier
   HiLink pgsqlComment   Comment
   HiLink pgsqlType      Type
-  HiLink pgsqlOperator  Statement
   HiLink pgsqlTodo      Todo
   delcommand HiLink
 endif