Support Postgresql multiple parenthesis (())

[grib0]

This request doesn't parse :

select avg((123.250) ::numeric)

although this one is ok :

select avg(123.250 ::numeric)

[wumpz]

Do you have an exception? Just thinking over it I would say, it should work.

[wumpz]

I included your statement as a test and it parses perfectly well. Could you provide an exception?

[grib0]

Sorry, I simplyfied my test too much :

This one does not parse :

select avg((extract(epoch from age(d1,d2)) / 2) ::numeric)

although this one parse :

select avg(extract(epoch from age(d1,d2)) / 2 ::numeric)

[wumpz]

You found a mayor flaw in JSqlParsers grammar. This does not work as well:

select (1/2)::numeric

I am on it but due to this grammar change I want to improve the tests there.

[grib0]

Great job, I'll test this version today or tomorrow.
Regards.