-- should fail

CREATE OR REPLACE VIEW viewtest AS

SELECT a, b::numeric FROM viewtest_tbl;

ERROR: cannot changedatatype of view column "b"

ERROR: cannot changedata type of view column "b"

DROP VIEW viewtest;

DROP TABLE viewtest_tbl;

SELECT '' AS count, p.f1, l.s, l.s # p.f1 AS intersection

FROM LSEG_TBL l, POINT_TBL p;

ERROR: operator does not exist: lseg # point

HINT: No operator matches the given name and argument type(s). You may need to add explicittypecasts.

HINT: No operator matches the given name and argument type(s). You may need to add explicittype casts.

-- closest point

SELECT '' AS thirty, p.f1, l.s, p.f1 ## l.s AS closest

FROM LSEG_TBL l, POINT_TBL p;

SELECT '' AS count, p.f1, l.s, l.s # p.f1 AS intersection

FROM LSEG_TBL l, POINT_TBL p;

ERROR: operator does not exist: lseg # point

HINT: No operator matches the given name and argument type(s). You may need to add explicittypecasts.

HINT: No operator matches the given name and argument type(s). You may need to add explicittype casts.

-- closest point

SELECT '' AS thirty, p.f1, l.s, p.f1 ## l.s AS closest

FROM LSEG_TBL l, POINT_TBL p;

--

-- conditio sine qua non

SHOW stats_start_collector; -- must be on

stats_start_collector

stats_start_collector

-----------------------

on

(1 row)

-- where we do mixed-type arithmetic. - thomas 2000-12-02

SELECT f1 + time '00:01' AS "Illegal" FROM TIME_TBL;

ERROR: operator is not unique: time without time zone + time without time zone

HINT: Could not choose a best candidate operator. You may need to add explicittypecasts.

HINT: Could not choose a best candidate operator. You may need to add explicittype casts.

-- where we do mixed-type arithmetic. - thomas 2000-12-02

SELECT f1 + time with time zone '00:01' AS "Illegal" FROM TIMETZ_TBL;

ERROR: operator does not exist: time with time zone + time with time zone

HINT: No operator matches the given name and argument type(s). You may need to add explicittypecasts.

HINT: No operator matches the given name and argument type(s). You may need to add explicittype casts.