colourized word list suggestion

[thiagonogueira]

First of all congrats and thank you for the great work!

Here are some words don't appear colourized on my sql files I believe it should be:

DROP
FUNCTION
PROCEDURE
NUMBER
CURSOR
COMMIT
EXECUTE
IMMEDIATE
RANK
OVER
PARTITION
BY
COUNT
SUM
EXISTS
PIVOT
UNPIVOT
NOTFOUND

I've taken a look at the source code but since I'm neither a regex nor a sql expert I could easily mess everything up if trying to implement by myself.

Kind Regards,
Thiago

[zabel-xyz]

Thank you for the list (some words are already colourized)

I'll complete the keyword list to improve syntax highlight (with your list and another)....

[thiagonogueira]

Not sure why, but some words you've posted are not working here...

[zabel-xyz]

procedure and function are special keywords.
Currently they are colored only when they appear at the beginning of the line (not after drop or create ...) and with a name after.

For other keywords:
Which theme do you use? Do they work with another color theme (e.g. Monokai)?

[thiagonogueira]

I use Humane theme. I've tested colouring schema with Monokai and it worked.

[zabel-xyz]

fix in version 0.0.9