Commiteec501c

committed

Fix recently added code for SQL years-months interval syntax so that

it behaves correctly for a leading minus sign, zero year value, andnonzero month value. Per discussion with Ron Mayer.

1 parent13fdd0e commiteec501cCopy full SHA for eec501c

File tree

-2

lines changed

-2

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`*`
`9`	`9`	`*`
`10`	`10`	`* IDENTIFICATION`
`11`		`- * $PostgreSQL: pgsql/src/backend/utils/adt/datetime.c,v 1.195 2008/10/02 13:47:38 tgl Exp $`
	`11`	`+ * $PostgreSQL: pgsql/src/backend/utils/adt/datetime.c,v 1.196 2008/11/08 20:51:49 tgl Exp $`
`12`	`12`	`*`
`13`	`13`	`*-------------------------------------------------------------------------`
`14`	`14`	`*/`
`@@ -2863,7 +2863,7 @@ DecodeInterval(char *field, int ftype, int nf, int range,`
`2863`	`2863`	`if (*cp!='\0')`
`2864`	`2864`	`returnDTERR_BAD_FORMAT;`
`2865`	`2865`	`type=DTK_MONTH;`
`2866`		`-if (val<0)`
	`2866`	`+if (*field[i]=='-')`
`2867`	`2867`	`val2=-val2;`
`2868`	`2868`	`val=val*MONTHS_PER_YEAR+val2;`
`2869`	`2869`	`fval=0;`

Comments

(0)