forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commit70530c8
committed
Adjust the parser to accept the typename syntax INTERVAL ... SECOND(n)
and the literal syntax INTERVAL 'string' ... SECOND(n), as required by theSQL standard. Our old syntax put (n) directly after INTERVAL, which wasa mistake, but will still be accepted for backward compatibility as wellas symmetry with the TIMESTAMP cases.Change intervaltypmodout to show it in the spec's way, too. (This couldpotentially affect clients, if there are any that analyze the typmod of anINTERVAL in any detail.)Also fix interval input to handle 'min:sec.frac' properly; I had overlookedthis case in my previous patch.Document the use of the interval fields qualifier, which up to now we hadnever mentioned in the docs. (I think the omission was intentional becauseit didn't work per spec; but it does now, or at least close enough to becredible.)1 parentd53a566 commit70530c8
File tree
6 files changed
+294
-56
lines changed- doc/src/sgml
- src
- backend
- parser
- utils/adt
- test/regress
- expected
- sql
6 files changed
+294
-56
lines changedLines changed: 39 additions & 7 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 |
| - | |
| 1 | + | |
2 | 2 |
| |
3 | 3 |
| |
4 | 4 |
| |
| |||
131 | 131 |
| |
132 | 132 |
| |
133 | 133 |
| |
134 |
| - | |
| 134 | + | |
135 | 135 |
| |
136 | 136 |
| |
137 | 137 |
| |
| |||
1420 | 1420 |
| |
1421 | 1421 |
| |
1422 | 1422 |
| |
1423 |
| - | |
| 1423 | + | |
1424 | 1424 |
| |
1425 | 1425 |
| |
1426 | 1426 |
| |
| |||
1505 | 1505 |
| |
1506 | 1506 |
| |
1507 | 1507 |
| |
| 1508 | + | |
| 1509 | + | |
| 1510 | + | |
| 1511 | + | |
| 1512 | + | |
| 1513 | + | |
| 1514 | + | |
| 1515 | + | |
| 1516 | + | |
| 1517 | + | |
| 1518 | + | |
| 1519 | + | |
| 1520 | + | |
| 1521 | + | |
| 1522 | + | |
| 1523 | + | |
| 1524 | + | |
| 1525 | + | |
| 1526 | + | |
| 1527 | + | |
| 1528 | + | |
| 1529 | + | |
| 1530 | + | |
| 1531 | + | |
1508 | 1532 |
| |
1509 | 1533 |
| |
1510 | 1534 |
| |
| |||
1928 | 1952 |
| |
1929 | 1953 |
| |
1930 | 1954 |
| |
1931 |
| - | |
| 1955 | + | |
1932 | 1956 |
| |
1933 | 1957 |
| |
1934 | 1958 |
| |
1935 | 1959 |
| |
1936 | 1960 |
| |
1937 |
| - | |
| 1961 | + | |
| 1962 | + | |
| 1963 | + | |
| 1964 | + | |
| 1965 | + | |
1938 | 1966 |
| |
1939 | 1967 |
| |
1940 | 1968 |
| |
1941 |
| - | |
1942 |
| - | |
| 1969 | + | |
| 1970 | + | |
| 1971 | + | |
| 1972 | + | |
| 1973 | + | |
| 1974 | + | |
1943 | 1975 |
| |
1944 | 1976 |
| |
1945 | 1977 |
| |
|
Lines changed: 114 additions & 42 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
11 | 11 |
| |
12 | 12 |
| |
13 | 13 |
| |
14 |
| - | |
| 14 | + | |
15 | 15 |
| |
16 | 16 |
| |
17 | 17 |
| |
| |||
292 | 292 |
| |
293 | 293 |
| |
294 | 294 |
| |
295 |
| - | |
| 295 | + | |
296 | 296 |
| |
297 | 297 |
| |
298 | 298 |
| |
| |||
1222 | 1222 |
| |
1223 | 1223 |
| |
1224 | 1224 |
| |
1225 |
| - | |
| 1225 | + | |
1226 | 1226 |
| |
1227 |
| - | |
| 1227 | + | |
| 1228 | + | |
1228 | 1229 |
| |
1229 | 1230 |
| |
1230 | 1231 |
| |
1231 | 1232 |
| |
1232 |
| - | |
1233 | 1233 |
| |
| 1234 | + | |
1234 | 1235 |
| |
1235 | 1236 |
| |
1236 | 1237 |
| |
1237 | 1238 |
| |
1238 | 1239 |
| |
1239 |
| - | |
1240 |
| - | |
1241 |
| - | |
1242 |
| - | |
1243 |
| - | |
1244 |
| - | |
1245 |
| - | |
1246 |
| - | |
| 1240 | + | |
| 1241 | + | |
| 1242 | + | |
| 1243 | + | |
| 1244 | + | |
| 1245 | + | |
| 1246 | + | |
| 1247 | + | |
| 1248 | + | |
| 1249 | + | |
| 1250 | + | |
| 1251 | + | |
| 1252 | + | |
| 1253 | + | |
| 1254 | + | |
| 1255 | + | |
| 1256 | + | |
| 1257 | + | |
1247 | 1258 |
| |
1248 | 1259 |
| |
1249 | 1260 |
| |
| |||
6983 | 6994 |
| |
6984 | 6995 |
| |
6985 | 6996 |
| |
6986 |
| - | |
6987 |
| - | |
| 6997 | + | |
6988 | 6998 |
| |
6989 | 6999 |
| |
6990 | 7000 |
| |
6991 | 7001 |
| |
6992 |
| - | |
6993 |
| - | |
| 7002 | + | |
| 7003 | + | |
| 7004 | + | |
| 7005 | + | |
| 7006 | + | |
| 7007 | + | |
| 7008 | + | |
| 7009 | + | |
| 7010 | + | |
| 7011 | + | |
| 7012 | + | |
| 7013 | + | |
6994 | 7014 |
| |
6995 | 7015 |
| |
6996 | 7016 |
| |
| |||
7337 | 7357 |
| |
7338 | 7358 |
| |
7339 | 7359 |
| |
7340 |
| - | |
7341 |
| - | |
7342 |
| - | |
7343 |
| - | |
7344 |
| - | |
7345 |
| - | |
| 7360 | + | |
| 7361 | + | |
| 7362 | + | |
| 7363 | + | |
| 7364 | + | |
| 7365 | + | |
| 7366 | + | |
| 7367 | + | |
| 7368 | + | |
| 7369 | + | |
| 7370 | + | |
| 7371 | + | |
7346 | 7372 |
| |
7347 |
| - | |
| 7373 | + | |
| 7374 | + | |
| 7375 | + | |
| 7376 | + | |
7348 | 7377 |
| |
7349 |
| - | |
| 7378 | + | |
| 7379 | + | |
| 7380 | + | |
| 7381 | + | |
7350 | 7382 |
| |
7351 |
| - | |
7352 |
| - | |
7353 |
| - | |
7354 |
| - | |
7355 |
| - | |
| 7383 | + | |
| 7384 | + | |
| 7385 | + | |
| 7386 | + | |
| 7387 | + | |
| 7388 | + | |
| 7389 | + | |
| 7390 | + | |
| 7391 | + | |
| 7392 | + | |
| 7393 | + | |
| 7394 | + | |
| 7395 | + | |
7356 | 7396 |
| |
7357 |
| - | |
7358 |
| - | |
7359 |
| - | |
7360 |
| - | |
7361 |
| - | |
7362 |
| - | |
7363 |
| - | |
| 7397 | + | |
| 7398 | + | |
| 7399 | + | |
| 7400 | + | |
| 7401 | + | |
| 7402 | + | |
| 7403 | + | |
| 7404 | + | |
| 7405 | + | |
| 7406 | + | |
| 7407 | + | |
| 7408 | + | |
| 7409 | + | |
| 7410 | + | |
| 7411 | + | |
| 7412 | + | |
| 7413 | + | |
| 7414 | + | |
| 7415 | + | |
| 7416 | + | |
| 7417 | + | |
| 7418 | + | |
| 7419 | + | |
| 7420 | + | |
| 7421 | + | |
| 7422 | + | |
| 7423 | + | |
| 7424 | + | |
| 7425 | + | |
| 7426 | + | |
| 7427 | + | |
7364 | 7428 |
| |
7365 | 7429 |
| |
7366 | 7430 |
| |
| |||
9014 | 9078 |
| |
9015 | 9079 |
| |
9016 | 9080 |
| |
9017 |
| - | |
9018 |
| - | |
9019 |
| - | |
| 9081 | + | |
9020 | 9082 |
| |
9021 | 9083 |
| |
9022 | 9084 |
| |
9023 | 9085 |
| |
9024 | 9086 |
| |
9025 |
| - | |
9026 |
| - | |
| 9087 | + | |
| 9088 | + | |
| 9089 | + | |
| 9090 | + | |
| 9091 | + | |
| 9092 | + | |
| 9093 | + | |
| 9094 | + | |
| 9095 | + | |
| 9096 | + | |
| 9097 | + | |
| 9098 | + | |
9027 | 9099 |
| |
9028 | 9100 |
| |
9029 | 9101 |
| |
|
Lines changed: 22 additions & 4 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
8 | 8 |
| |
9 | 9 |
| |
10 | 10 |
| |
11 |
| - | |
| 11 | + | |
12 | 12 |
| |
13 | 13 |
| |
14 | 14 |
| |
| |||
2256 | 2256 |
| |
2257 | 2257 |
| |
2258 | 2258 |
| |
2259 |
| - | |
2260 |
| - | |
2261 |
| - | |
| 2259 | + | |
| 2260 | + | |
| 2261 | + | |
| 2262 | + | |
| 2263 | + | |
| 2264 | + | |
| 2265 | + | |
| 2266 | + | |
| 2267 | + | |
| 2268 | + | |
| 2269 | + | |
| 2270 | + | |
| 2271 | + | |
| 2272 | + | |
| 2273 | + | |
| 2274 | + | |
| 2275 | + | |
| 2276 | + | |
| 2277 | + | |
2262 | 2278 |
| |
2263 | 2279 |
| |
2264 | 2280 |
| |
| |||
2284 | 2300 |
| |
2285 | 2301 |
| |
2286 | 2302 |
| |
| 2303 | + | |
| 2304 | + | |
2287 | 2305 |
| |
2288 | 2306 |
| |
2289 | 2307 |
| |
|
Lines changed: 3 additions & 3 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
8 | 8 |
| |
9 | 9 |
| |
10 | 10 |
| |
11 |
| - | |
| 11 | + | |
12 | 12 |
| |
13 | 13 |
| |
14 | 14 |
| |
| |||
744 | 744 |
| |
745 | 745 |
| |
746 | 746 |
| |
747 |
| - | |
| 747 | + | |
748 | 748 |
| |
749 | 749 |
| |
750 | 750 |
| |
| |||
881 | 881 |
| |
882 | 882 |
| |
883 | 883 |
| |
884 |
| - | |
| 884 | + | |
885 | 885 |
| |
886 | 886 |
| |
887 | 887 |
| |
|
0 commit comments
Comments
(0)