-- Shorthand values

-- Not directly usable for regression testing since these are not constants.

-- So, just try to test parser and hope for the best - thomas 97/04/26

-- NB: could get a failure if local midnight passes during the next few

-- statements.

INSERT INTO TIMESTAMP_TBL VALUES ('now');

INSERT INTO TIMESTAMP_TBL VALUES ('current');

INSERT INTO TIMESTAMP_TBL VALUES ('today');

BEGIN;

INSERT INTO TIMESTAMP_TBL VALUES ('now');

INSERT INTO TIMESTAMP_TBL VALUES ('now');

SELECT count(*) AS two FROM TIMESTAMP_TBL WHERE d1 = timestamp without time zone 'now';

SELECT count(*) AS two FROM TIMESTAMP_TBL WHERE d1 = timestamp(2) without time zone 'now';

two

-----

2

BEGIN;

INSERT INTO TIMESTAMPTZ_TBL VALUES ('now');

INSERT INTO TIMESTAMPTZ_TBL VALUES ('now');

SELECT count(*) AS two FROM TIMESTAMPTZ_TBL WHERE d1 = timestamp with time zone 'now';

SELECT count(*) AS two FROM TIMESTAMPTZ_TBL WHERE d1 = timestamp(2) with time zone 'now';

two

-----

2

INSERT INTO TIMESTAMP_TBLVALUES ('now');

INSERT INTO TIMESTAMP_TBLVALUES ('current');

BEGIN;

INSERT INTO TIMESTAMP_TBLVALUES ('now');

INSERT INTO TIMESTAMP_TBLVALUES ('now');

SELECTcount(*)AS twoFROM TIMESTAMP_TBLWHERE d1=timestamp without time zone'now';

SELECTcount(*)AS twoFROM TIMESTAMP_TBLWHERE d1=timestamp(2) without time zone'now';

END;

DELETEFROM TIMESTAMP_TBL;

BEGIN;

INSERT INTO TIMESTAMPTZ_TBLVALUES ('now');

INSERT INTO TIMESTAMPTZ_TBLVALUES ('now');

SELECTcount(*)AS twoFROM TIMESTAMPTZ_TBLWHERE d1=timestamp with time zone'now';

SELECTcount(*)AS twoFROM TIMESTAMPTZ_TBLWHERE d1=timestamp(2) with time zone'now';

END;

DELETEFROM TIMESTAMPTZ_TBL;