computations should adjust based on the time zone rules.

o Fix SELECT '0.01 years'::interval, '0.01 months'::interval

o Fix SELECT INTERVAL '1' MONTH

o Add a GUC variable to allow output of interval values in ISO8601

format

o Improve timestamptz subtraction to be DST-aware

o Fix interval display to support values exceeding 2^31 hours

o Add overflow checking to timestamp and interval arithmetic

o Add ISO INTERVAL handling

o Add support for day-time syntax, INTERVAL '1 2:03:04' DAY TO

o-Add support for day-time syntax, INTERVAL '1 2:03:04' DAY TO

SECOND

o Fix SELECT INTERVAL '1' MONTH

o Add support for year-month syntax, INTERVAL '50-6' YEAR TO MONTH

o For syntax that isn't uniquely ISO or PG syntax, like '1:30' or

'1', treat as ISO if there is a range specification clause,

A_Const *n = (A_Const *) makeStringConst($2,$1);

if ($3 != INTERVAL_FULL_RANGE)

{

ereport(LOG, (errmsg("1.0")));

if (($3 & ~(INTERVAL_MASK(HOUR) | INTERVAL_MASK(MINUTE))) !=0)

ereport(ERROR,

(errcode(ERRCODE_SYNTAX_ERROR),

{

A_Const *n = (A_Const *) makeStringConst($5,$1);

ereport(LOG, (errmsg("2.0")));

if ($3 <0)

ereport(ERROR,

(errcode(ERRCODE_INVALID_PARAMETER_VALUE),

| ConstDatetime{$$ =$1; }

| ConstInterval opt_interval

{

ereport(LOG, (errmsg("3.0")));

$$ =$1;

if ($2 != INTERVAL_FULL_RANGE)

$$->typmod = INTERVAL_TYPMOD(INTERVAL_FULL_PRECISION,$2);

}

| ConstInterval'(' Iconst')' opt_interval

{

ereport(LOG, (errmsg("4.0")));

$$ =$1;

if ($3 <0)

ereport(ERROR,

}

| type_name attrs

{

ereport(LOG, (errmsg("5.0")));

$$ = makeNode(TypeName);

$$->names = lcons(makeString($1),$2);

$$->typmod = -1;

| ConstInterval Sconst opt_interval

{

A_Const *n =makeNode(A_Const);

ereport(LOG, (errmsg("6.0")));

n->typename = $1;

n->val.type = T_String;

n->val.val.str = $2;

| ConstInterval'(' Iconst')' Sconst opt_interval

{

A_Const *n =makeNode(A_Const);

ereport(LOG, (errmsg("7.0")));

n->typename = $1;

n->val.type = T_String;

n->val.val.str = $5;