diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-05-03 04:11:08 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-05-03 04:11:08 +0000 |
| commit | 8338cc03a8915e28024981d09193612ec4a83819 (patch) | |
| tree | 8845f3a7695af8370cb60c2461d39e70be667584 /contrib/spi | |
| parent | 53cedcac22bca29bb6ac766b04d5dd08db77ac03 (diff) | |
| download | postgresql-8338cc03a8915e28024981d09193612ec4a83819.tar.gz | |
Remove the last traces of datatypes datetime and timespan.
Diffstat (limited to 'contrib/spi')
| -rw-r--r-- | contrib/spi/moddatetime.example | 2 | ||||
| -rw-r--r-- | contrib/spi/refint.c | 2 | ||||
| -rw-r--r-- | contrib/spi/timetravel.example | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/contrib/spi/moddatetime.example b/contrib/spi/moddatetime.example index 25a54e3a33..e4a713c12a 100644 --- a/contrib/spi/moddatetime.example +++ b/contrib/spi/moddatetime.example @@ -3,7 +3,7 @@ DROP TABLE mdt; CREATE TABLE mdt ( id int4, idesc text, - moddate datetime DEFAULT datetime(CURRENT_TIMESTAMP) NOT NULL + moddate timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL ); CREATE TRIGGER mdt_moddatetime diff --git a/contrib/spi/refint.c b/contrib/spi/refint.c index 82a07871fb..55c0fd13e6 100644 --- a/contrib/spi/refint.c +++ b/contrib/spi/refint.c @@ -450,7 +450,7 @@ check_foreign_key(PG_FUNCTION_ARGS) if ((strcmp(type, "text") && strcmp(type, "varchar") && strcmp(type, "char") && strcmp(type, "bpchar") && - strcmp(type, "date") && strcmp(type, "datetime")) == 0) + strcmp(type, "date") && strcmp(type, "timestamp")) == 0) is_char_type = 1; #ifdef DEBUG_QUERY elog(DEBUG3, "Check_foreign_key Debug value %s type %s %d", diff --git a/contrib/spi/timetravel.example b/contrib/spi/timetravel.example index fa76c25017..4244bed19f 100644 --- a/contrib/spi/timetravel.example +++ b/contrib/spi/timetravel.example @@ -18,7 +18,7 @@ insert into tttest(price_id, price_val) values (2, 2); insert into tttest(price_id, price_val,price_off) values (3, 3, 'infinity'); insert into tttest(price_id, price_val,price_off) values (3, 3, - datetime_abstime(datetime_mi_span('now', '100'))); + abstime('now'::timestamp - '100 days'::interval)); insert into tttest(price_id, price_val,price_on) values (3, 3, 'infinity'); select * from tttest; |