Sender: owner-postgres95@postgres.Berkeley.EDU
X-Return-Path: andrew_yu
Received: from hiv.yahoo.com (hiv.yahoo.com [205.216.162.41]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id SAA18162 for <postgres95@postgres.berkeley.edu>; Sun, 5 Nov 1995 18:41:39 -0800
Received: (from lobo@localhost) by hiv.yahoo.com (8.6.12/8.6.9) id SAA00396; Sun, 5 Nov 1995 18:41:11 -0800
Date: Sun, 5 Nov 1995 18:41:11 -0800
From: "Donald A. Lobo" <lobo@yahoo.com>
Message-Id: <199511060241.SAA00396@hiv.yahoo.com>
To: postgres95@postgres.Berkeley.EDU
Subject: Regression test fails on pg95 (patch level 14), linux 1.2.13, gcc 2.7.0
Reply-To: lobo@yahoo.com
Resent-To: postgres95-redist
Resent-Date: Sun, 05 Nov 95 18:41:41 -0800
Resent-From: pglite
Resent-XMts: smtp


To report a bug, please complete the following form and send it by
email to postgres95@postgres.berkeley.edu

============================================================================
                        POSTGRES95 BUG REPORT TEMPLATE
============================================================================


Your name		:	Donald A. Lobo
Your email address	:	lobo@yahoo.com


System Configuration
---------------------
  Architecture (example: DEC Alpha AXP)  	:  Intel 586 (X386)

  Operating System (example: OSF/1 3.2)  	:  Linux, ELF 1.2.13

  Postgres95 version (example: Postgres95-1.0) :   Postgres95-1.0 (applied all patches till p14)

  Compiler used (example:  gcc 2.6.3)		:  2.7.0


Please enter a FULL description of your problem:
------------------------------------------------

1. Clean build and install of pg95 on above box
2. regression test fails

snippet of error message is follows: 

QUERY: SELECT onek.unique1, onek.stringu1
   WHERE onek.unique1 > 980
   ORDER BY stringu1 using <;
WARN:cannot write block 0 of temp_252078
QUERY: SELECT onek.unique1, onek.string4
   WHERE onek.unique1 > 980
   ORDER BY string4 using <, unique1 using >;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT onek.unique1, onek.string4
   WHERE onek.unique1 > 980
   ORDER BY string4 using >, unique1 using <;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT onek.unique1, onek.string4
   WHERE onek.unique1 < 20
   ORDER BY unique1 using >, string4 using <;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079

Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 
----------------------------------------------------------------------

Can be reproduced using basics.source in ~postgres95/src/tutorial also.


If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

=============== destroying old regression database... =================
WARN:destroydb: database regression does not exist.
destroydb: database destroy failed on regression.
=============== creating new regression database... =================
QUERY: CREATE FUNCTION circle_in(opaque)
   RETURNS circle
   AS '/usr/local/postgres95/src/test/regress/obj/regress.so'
   LANGUAGE 'c';
NOTICE:ProcedureDefine: type 'circle' is not yet defined
QUERY: CREATE FUNCTION circle_out(opaque)
   RETURNS opaque
   AS '/usr/local/postgres95/src/test/regress/obj/regress.so'
   LANGUAGE 'c';
QUERY: CREATE TYPE circle (
   internallength = 24,
   input = circle_in,
   output = circle_out,
   alignment = double
);
QUERY: CREATE TYPE city_budget (
   internallength = 16,
   input = int44in,
   output = int44out,
   element = int4
);
QUERY: CREATE TABLE hobbies_r (
	name		text,
	person 		text
);
QUERY: CREATE TABLE equipment_r (
	name 		text,
	hobby		text
);
QUERY: CREATE TABLE onek (
	unique1		int4,
	unique2		int4,
	two		int4,
	four		int4,
	ten		int4,
	twenty		int4,
	hundred		int4,
	thousand	int4,
	twothousand	int4,
	fivethous	int4,
	tenthous	int4,
	odd		int4,
	even		int4,
	stringu1	char16,
	stringu2	char16,
	string4		char16
);
QUERY: CREATE TABLE tenk1 (
	unique1		int4,
	unique2		int4,
	two		int4,
	four		int4,
	ten		int4,
	twenty		int4,
	hundred		int4,
	thousand	int4,
	twothousand	int4,
	fivethous	int4,
	tenthous	int4,
	odd		int4,
	even		int4,
	stringu1	char16,
	stringu2	char16,
	string4		char16
);
QUERY: CREATE TABLE tenk2 (
	unique1 	int4,
	unique2 	int4,
	two 	 	int4,
	four 		int4,
	ten		int4,
	twenty 		int4,
	hundred 	int4,
	thousand 	int4,
	twothousand 	int4,
	fivethous 	int4,
	tenthous	int4,
	odd		int4,
	even		int4,
	stringu1	char16,
	stringu2	char16,
	string4		char16
);
QUERY: CREATE TABLE person (
	name 		text,
	age		int4,
	location 	point
);
QUERY: CREATE TABLE emp (
	salary 		int4,
	manager 	char16
) INHERITS (person);
QUERY: CREATE TABLE student (
	gpa 		float8
) INHERITS (person);
QUERY: CREATE TABLE stud_emp (
	percent 	int4
) INHERITS (emp, student);
QUERY: CREATE TABLE city (
	name		char16,
	location 	box,
	budget 		city_budget
);
QUERY: CREATE TABLE dept (
	dname		char16,
	mgrname 	text
);
QUERY: CREATE TABLE slow_emp4000 (
	home_base	 box
);
QUERY: CREATE TABLE fast_emp4000 (
	home_base	 box
);
QUERY: CREATE TABLE road (
	name		text,
	thepath 	path
);
QUERY: CREATE TABLE ihighway () INHERITS (road);
QUERY: CREATE TABLE shighway (
	surface		text
) INHERITS (road);
QUERY: CREATE TABLE real_city (
	pop		int4,
	cname		text,
	outline 	path
);
QUERY: CREATE TABLE a_star (
	class		char,
	a 		int4
);
QUERY: CREATE TABLE b_star (
	b 		text
) INHERITS (a_star);
QUERY: CREATE TABLE c_star (
	c 		char16
) INHERITS (a_star);
QUERY: CREATE TABLE d_star (
	d 		float8
) INHERITS (b_star, c_star);
QUERY: CREATE TABLE e_star (
	e 		int2
) INHERITS (c_star);
QUERY: CREATE TABLE f_star (
	f 		polygon
) INHERITS (e_star);
QUERY: CREATE TABLE aggtest (
	a 		int2,
	b		float4
);
QUERY: CREATE TABLE arrtest (
	a 		int2[],
	b 		int4[][][],
	c 		char16[],
	d		text[][],
	e 		float8[]
);
QUERY: CREATE TABLE hash_i4_heap (
	seqno 		int4,
	random 		int4
);
QUERY: CREATE TABLE hash_c16_heap (
	seqno 		int4,
	random 		char16
);
QUERY: CREATE TABLE hash_txt_heap (
	seqno 		int4,
	random 		text
);
QUERY: CREATE TABLE hash_f8_heap (
	seqno		int4,
	random 		float8
);
QUERY: CREATE TABLE bt_i4_heap (
	seqno 		int4,
	random 		int4
);
QUERY: CREATE TABLE bt_c16_heap (
	seqno 		char16,
	random 		int4
);
QUERY: CREATE TABLE bt_txt_heap (
	seqno 		text,
	random 		int4
);
QUERY: CREATE TABLE bt_f8_heap (
	seqno 		float8,
	random 		int4
);
QUERY: CREATE FUNCTION hobbies(person)
   RETURNS setof hobbies_r
   AS 'select * from hobbies_r where person = $1.name'
   LANGUAGE 'sql';
QUERY: CREATE FUNCTION hobby_construct(text, text)
   RETURNS hobbies_r
   AS 'select $1 as name, $2 as hobby'
   LANGUAGE 'sql';
QUERY: CREATE FUNCTION equipment(hobbies_r)
   RETURNS setof equipment_r
   AS 'select * from equipment_r where hobby = $1.name'
   LANGUAGE 'sql';
QUERY: CREATE FUNCTION user_relns()
   RETURNS setof char16
   AS 'select relname
       from pg_class
       where relname !~ ''pg_.*'' and
             relkind <> ''i'' '
   LANGUAGE 'sql';
QUERY: CREATE FUNCTION pt_in_circle(point, circle)
   RETURNS int4
   AS '/usr/local/postgres95/src/test/regress/obj/regress.so'
   LANGUAGE 'c';
QUERY: CREATE FUNCTION overpaid(emp)
   RETURNS bool
   AS '/usr/local/postgres95/src/test/regress/obj/regress.so'
   LANGUAGE 'c';
QUERY: CREATE FUNCTION boxarea(box)
   RETURNS int4
   AS '/usr/local/postgres95/src/test/regress/obj/regress.so'
   LANGUAGE 'c';
QUERY: CREATE FUNCTION interpt_pp(path, path)
   RETURNS point
   AS '/usr/local/postgres95/src/test/regress/obj/regress.so'
   LANGUAGE 'c';
QUERY: CREATE FUNCTION reverse_c16(char16)
   RETURNS char16
   AS '/usr/local/postgres95/src/test/regress/obj/regress.so'
   LANGUAGE 'c';
QUERY: LOAD '/usr/local/postgres95/src/test/regress/obj/regress.so'
COPY onek FROM '/usr/local/postgres95/src/test/regress/data/onek.data';
QUERY: COPY tenk1 FROM '/usr/local/postgres95/src/test/regress/data/tenk.data';
QUERY: INSERT INTO tenk2 VALUES (tenk1.*);
QUERY: SELECT * INTO TABLE onek2 FROM onek;
QUERY: COPY slow_emp4000 FROM '/usr/local/postgres95/src/test/regress/data/rect.data';
QUERY: INSERT INTO fast_emp4000 VALUES (slow_emp4000.*);
QUERY: COPY person FROM '/usr/local/postgres95/src/test/regress/data/person.data';
QUERY: COPY emp FROM '/usr/local/postgres95/src/test/regress/data/emp.data';
QUERY: COPY student FROM '/usr/local/postgres95/src/test/regress/data/student.data';
QUERY: COPY stud_emp FROM '/usr/local/postgres95/src/test/regress/data/stud_emp.data';
QUERY: SELECT *
   INTO TABLE Bprime
   FROM tenk1
   WHERE unique2 < 1000;
QUERY: INSERT INTO hobbies_r (name, person)
   SELECT 'posthacking', p.name
   FROM person* p
   WHERE p.name = 'mike' or p.name = 'jeff';
QUERY: INSERT INTO hobbies_r (name, person)
   SELECT 'basketball', p.name
   FROM person p
   WHERE p.name = 'joe' or p.name = 'sally';
QUERY: INSERT INTO hobbies_r (name) VALUES ('skywalking');
QUERY: INSERT INTO equipment_r (name, hobby) VALUES ('advil', 'posthacking');
QUERY: INSERT INTO equipment_r (name, hobby) VALUES ('peet''s coffee', 'posthacking');
QUERY: INSERT INTO equipment_r (name, hobby) VALUES ('hightops', 'basketball');
QUERY: INSERT INTO equipment_r (name, hobby) VALUES ('guts', 'skywalking');
QUERY: COPY road FROM '/usr/local/postgres95/src/test/regress/data/streets.data';
QUERY: COPY real_city FROM '/usr/local/postgres95/src/test/regress/data/real_city.data';
QUERY: SELECT *
   INTO TABLE ramp
   FROM road
   WHERE name ~ '.*Ramp';
QUERY: INSERT INTO ihighway
   SELECT *
   FROM road
   WHERE name ~ 'I- .*';
QUERY: INSERT INTO shighway
   SELECT *
   FROM road
   WHERE name ~ 'State Hwy.*';
QUERY: UPDATE shighway
   SET surface = 'asphalt'
INSERT INTO a_star (class, a) VALUES ('a', 1);
QUERY: INSERT INTO a_star (class, a) VALUES ('a', 2);
QUERY: INSERT INTO a_star (class) VALUES ('a');
QUERY: INSERT INTO b_star (class, a, b) VALUES ('b', 3, 'mumble'::text);
QUERY: INSERT INTO b_star (class, a) VALUES ('b', 4);
QUERY: INSERT INTO b_star (class, b) VALUES ('b', 'bumble'::text);
QUERY: INSERT INTO b_star (class) VALUES ('b');
QUERY: INSERT INTO c_star (class, a, c) VALUES ('c', 5, 'hi mom'::char16);
QUERY: INSERT INTO c_star (class, a) VALUES ('c', 6);
QUERY: INSERT INTO c_star (class, c) VALUES ('c', 'hi paul'::char16);
QUERY: INSERT INTO c_star (class) VALUES ('c');
QUERY: INSERT INTO d_star (class, a, b, c, d)
   VALUES ('d', 7, 'grumble'::text, 'hi sunita'::char16, '0.0'::float8);
QUERY: INSERT INTO d_star (class, a, b, c)
   VALUES ('d', 8, 'stumble'::text, 'hi koko'::char16);
QUERY: INSERT INTO d_star (class, a, b, d)
   VALUES ('d', 9, 'rumble'::text, '1.1'::float8);
QUERY: INSERT INTO d_star (class, a, c, d)
   VALUES ('d', 10, 'hi kristin'::char16, '10.01'::float8);
QUERY: INSERT INTO d_star (class, b, c, d)
   VALUES ('d', 'crumble'::text, 'hi boris'::char16, '100.001'::float8);
QUERY: INSERT INTO d_star (class, a, b)
   VALUES ('d', 11, 'fumble'::text)
INSERT INTO d_star (class, a, c)
   VALUES ('d', 12, 'hi avi'::char16);
QUERY: INSERT INTO d_star (class, a, d)
   VALUES ('d', 13, '1000.0001'::float8);
QUERY: INSERT INTO d_star (class, b, c)
   VALUES ('d', 'tumble'::text, 'hi andrew'::char16);
QUERY: INSERT INTO d_star (class, b, d)
   VALUES ('d', 'humble'::text, '10000.00001'::float8);
QUERY: INSERT INTO d_star (class, c, d)
   VALUES ('d', 'hi ginger'::char16, '100000.000001'::float8);
QUERY: INSERT INTO d_star (class, a) VALUES ('d', 14);
QUERY: INSERT INTO d_star (class, b) VALUES ('d', 'jumble'::text);
QUERY: INSERT INTO d_star (class, c) VALUES ('d', 'hi jolly'::char16);
QUERY: INSERT INTO d_star (class, d) VALUES ('d', '1000000.0000001'::float8);
QUERY: INSERT INTO d_star (class) VALUES ('d');
QUERY: INSERT INTO e_star (class, a, c, e)
   VALUES ('e', 15, 'hi carol'::char16, '-1'::int2);
QUERY: INSERT INTO e_star (class, a, c)
   VALUES ('e', 16, 'hi bob'::char16);
QUERY: INSERT INTO e_star (class, a, e)
   VALUES ('e', 17, '-2'::int2);
QUERY: INSERT INTO e_star (class, c, e)
   VALUES ('e', 'hi michelle'::char16, '-3'::int2);
QUERY: INSERT INTO e_star (class, a)
   VALUES ('e', 18);
QUERY: INSERT INTO e_star (class, c)
   VALUES ('e', 'hi elisa'::char16);
QUERY: INSERT INTO e_star (class, e)
   VALUES ('e', '-4'::int2);
QUERY: INSERT INTO f_star (class, a, c, e, f)
   VALUES ('f', 19, 'hi claire'::char16, '-5'::int2, '(1,2,3,4)'::polygon);
QUERY: INSERT INTO f_star (class, a, c, e)
   VALUES ('f', 20, 'hi mike'::char16, '-6'::int2);
QUERY: INSERT INTO f_star (class, a, c, f)
   VALUES ('f', 21, 'hi marcel'::char16, '(11,22,33,44,55,66)'::polygon);
QUERY: INSERT INTO f_star (class, a, e, f)
   VALUES ('f', 22, '-7'::int2, '(111,222,333,444,555,666,777,888)'::polygon);
QUERY: INSERT INTO f_star (class, c, e, f)
   VALUES ('f', 'hi keith'::char16, '-8'::int2,
	   '(1111,2222,3333,4444)'::polygon);
QUERY: INSERT INTO f_star (class, a, c)
   VALUES ('f', 24, 'hi marc'::char16);
QUERY: INSERT INTO f_star (class, a, e)
   VALUES ('f', 25, '-9'::int2);
QUERY: INSERT INTO f_star (class, a, f)
   VALUES ('f', 26, '(11111,22222,33333,44444)'::polygon);
QUERY: INSERT INTO f_star (class, c, e)
   VALUES ('f', 'hi allison'::char16, '-10'::int2);
QUERY: INSERT INTO f_star (class, c, f)
   VALUES ('f', 'hi jeff'::char16,
           '(111111,222222,333333,444444)'::polygon);
QUERY: INSERT INTO f_star (class, e, f)
   VALUES ('f', '-11'::int2, '(1111111,2222222,3333333,4444444)'::polygon);
QUERY: INSERT INTO f_star (class, a) VALUES ('f', 27);
QUERY: INSERT INTO f_star (class, c) VALUES ('f', 'hi carl'::char16);
QUERY: INSERT INTO f_star (class, e) VALUES ('f', '-12'::int2);
QUERY: INSERT INTO f_star (class, f)
   VALUES ('f', '(11111111,22222222,33333333,44444444)'::polygon);
QUERY: INSERT INTO f_star (class) VALUES ('f');
QUERY: COPY hash_i4_heap FROM '/usr/local/postgres95/src/test/regress/data/hash.data';
QUERY: COPY hash_c16_heap FROM '/usr/local/postgres95/src/test/regress/data/hash.data';
QUERY: COPY hash_txt_heap FROM '/usr/local/postgres95/src/test/regress/data/hash.data';
QUERY: COPY hash_f8_heap FROM '/usr/local/postgres95/src/test/regress/data/hash.data';
QUERY: COPY bt_i4_heap FROM '/usr/local/postgres95/src/test/regress/data/desc.data';
QUERY: COPY bt_c16_heap FROM '/usr/local/postgres95/src/test/regress/data/hash.data';
QUERY: COPY bt_txt_heap FROM '/usr/local/postgres95/src/test/regress/data/desc.data';
QUERY: COPY bt_f8_heap FROM '/usr/local/postgres95/src/test/regress/data/hash.data';
QUERY: INSERT INTO arrtest (a[5], b[2][1][2], c, d)
   VALUES ('{1,2,3,4,5}', '{{{},{1,2}}}', '{}', '{}');
QUERY: INSERT INTO arrtest (a, b[2][2][1], c, d, e)
   VALUES ('{11,12,23}', '{{3,4},{4,5}}', '{"foobar"}',
           '{{"elt1", "elt2"}}', '{"3.4", "6.7"}');
QUERY: INSERT INTO arrtest (a, b[1][2][2], c, d[2][1])
   VALUES ('{}', '{3,4}', '{foo,bar}', '{bar,foo}');
QUERY: CREATE TABLE iportaltest (
	i		int4,
	d		float4,
	p		polygon
);
QUERY: INSERT INTO iportaltest (i, d, p)
   VALUES (1, 3.567, '(3.0,4.0,1.0,2.0)'::polygon);
QUERY: INSERT INTO iportaltest (i, d, p)
   VALUES (2, 89.05, '(4.0,3.0,2.0,1.0)'::polygon);
QUERY: CREATE INDEX onek_unique1 ON onek USING btree(unique1 int4_ops);
QUERY: CREATE INDEX onek_unique2 ON onek USING btree(unique2 int4_ops);
QUERY: CREATE INDEX onek_hundred ON onek USING btree(hundred int4_ops);
QUERY: CREATE INDEX onek_stringu1 ON onek USING btree(stringu1 char16_ops);
QUERY: CREATE INDEX tenk1_unique1 ON tenk1 USING btree(unique1 int4_ops);
QUERY: CREATE INDEX tenk1_unique2 ON tenk1 USING btree(unique2 int4_ops);
QUERY: CREATE INDEX tenk1_hundred ON tenk1 USING btree(hundred int4_ops);
QUERY: CREATE INDEX tenk2_unique1 ON tenk2 USING btree(unique1 int4_ops);
QUERY: CREATE INDEX tenk2_unique2 ON tenk2 USING btree(unique2 int4_ops);
QUERY: CREATE INDEX tenk2_hundred ON tenk2 USING btree(hundred int4_ops);
QUERY: CREATE INDEX rix ON road USING btree (name text_ops);
QUERY: CREATE INDEX iix ON ihighway USING btree (name text_ops);
QUERY: CREATE INDEX six ON shighway USING btree (name text_ops);
QUERY: CREATE INDEX bt_i4_index ON bt_i4_heap USING btree (seqno int4_ops);
QUERY: CREATE INDEX bt_c16_index ON bt_c16_heap USING btree (seqno char16_ops);
QUERY: CREATE INDEX bt_txt_index ON bt_txt_heap USING btree (seqno text_ops);
QUERY: CREATE INDEX bt_f8_index ON bt_f8_heap USING btree (seqno float8_ops);
QUERY: CREATE INDEX onek2_u1_prtl ON onek2 USING btree(unique1 int4_ops)
	where onek2.unique1 < 20 or onek2.unique1 > 980;
QUERY: CREATE INDEX onek2_u2_prtl ON onek2 USING btree(unique2 int4_ops)
	where onek2.stringu1 < 'B';
QUERY: EXTEND INDEX onek2_u2_prtl where onek2.stringu1 < 'C';
QUERY: EXTEND INDEX onek2_u2_prtl;
QUERY: CREATE INDEX onek2_stu1_prtl ON onek2 USING btree(stringu1 char16_ops)
	where onek2.stringu1 >= 'J' and onek2.stringu1 < 'K';
QUERY: CREATE INDEX rect2ind ON fast_emp4000 USING rtree (home_base bigbox_ops);
QUERY: CREATE INDEX hash_i4_index ON hash_i4_heap USING hash (random int4_ops);
QUERY: CREATE INDEX hash_c16_index ON hash_c16_heap USING hash (random char16_ops);
QUERY: CREATE INDEX hash_txt_index ON hash_txt_heap USING hash (random text_ops);
QUERY: CREATE INDEX hash_f8_index ON hash_f8_heap USING hash (random float8_ops);
QUERY: CREATE OPERATOR ## (
   leftarg = path,
   rightarg = path,
   procedure = path_inter,
   commutator = ##
);
QUERY: CREATE OPERATOR <% (
   leftarg = point,
   rightarg = circle,
   procedure = pt_in_circle,
   commutator = >=%
);
QUERY: CREATE OPERATOR @#@ (
   rightarg = int4,		-- left unary
   procedure = int4fac
);
QUERY: CREATE OPERATOR #@# (
   leftarg = int4,		-- right unary
   procedure = int4fac
);
QUERY: CREATE OPERATOR #%# (
   leftarg = int4,		-- right unary
   procedure = int4fac
);
QUERY: CREATE VIEW street AS
   SELECT r.name, r.thepath, c.cname AS cname
   FROM road r, real_city c
   WHERE c.outline ## r.thepath;
QUERY: CREATE VIEW iexit AS
   SELECT ih.name, ih.thepath,
	interpt_pp(ih.thepath, r.thepath) AS exit
   FROM ihighway ih, ramp r
   WHERE ih.thepath ## r.thepath;
QUERY: CREATE VIEW toyemp AS
   SELECT name, age, location, 12*salary AS annualsal
   FROM emp;
QUERY: CREATE AGGREGATE newavg (
   sfunc1 = int4pl, basetype = int4, stype1 = int4,
   sfunc2 = int4inc, stype2 = int4,
   finalfunc = int4div,
   initcond1 = '0', initcond2 = '0'
);
QUERY: CREATE AGGREGATE newsum (
   sfunc1 = int4pl, basetype = int4, stype1 = int4,
   initcond1 = '0'
);
QUERY: CREATE AGGREGATE newcnt (
   sfunc2 = int4inc, basetype = int4, stype2 = int4,
   initcond2 = '0'
);
QUERY: VACUUM;
QUERY: SELECT relname, relhasindex
   FROM pg_class
   WHERE relhasindex
   ORDER BY relname;
-----------------------------
| relname     | relhasindex |
-----------------------------
| bt_c16_heap | t           |
-----------------------------
| bt_f8_heap  | t           |
-----------------------------
| bt_i4_heap  | t           |
-----------------------------
| bt_txt_heap | t           |
-----------------------------
| fast_emp4000| t           |
-----------------------------
| hash_c16_heap| t           |
-----------------------------
| hash_f8_heap| t           |
-----------------------------
| hash_i4_heap| t           |
-----------------------------
| hash_txt_heap| t           |
-----------------------------
| ihighway    | t           |
-----------------------------
| onek        | t           |
-----------------------------
| onek2       | t           |
-----------------------------
| pg_attribute| t           |
-----------------------------
| pg_class    | t           |
-----------------------------
| pg_proc     | t           |
-----------------------------
| pg_type     | t           |
-----------------------------
| road        | t           |
-----------------------------
| shighway    | t           |
-----------------------------
| tenk1       | t           |
-----------------------------
| tenk2       | t           |
-----------------------------
=============== running regression queries ... =================
QUERY: SELECT 1 AS one;
---------------
| one         |
---------------
| 1           |
---------------
QUERY: SELECT 't'::bool AS true;
---------------
| true        |
---------------
| t           |
---------------
QUERY: SELECT 'f'::bool AS false;
---------------
| false       |
---------------
| f           |
---------------
QUERY: SELECT 't'::bool or 'f'::bool AS true;
---------------
| true        |
---------------
| t           |
---------------
QUERY: SELECT 't'::bool and 'f'::bool AS false;
---------------
| false       |
---------------
| f           |
---------------
QUERY: SELECT not 'f'::bool AS true;
---------------
| true        |
---------------
| t           |
---------------
QUERY: SELECT 't'::bool = 'f'::bool AS false;
---------------
| false       |
---------------
| f           |
---------------
QUERY: SELECT 't'::bool <> 'f'::bool AS true;
---------------
| true        |
---------------
| t           |
---------------
QUERY: CREATE TABLE BOOLTBL1 (f1 bool);
QUERY: INSERT INTO BOOLTBL1 (f1) VALUES ('t'::bool);
QUERY: INSERT INTO BOOLTBL1 (f1) VALUES ('True'::bool);
QUERY: INSERT INTO BOOLTBL1 (f1) VALUES ('true'::bool);
QUERY: SELECT '' AS t_3, BOOLTBL1.*;
-----------------------------
| t_3         | f1          |
-----------------------------
|             | t           |
-----------------------------
|             | t           |
-----------------------------
|             | t           |
-----------------------------
QUERY: SELECT '' AS t_3, BOOLTBL1.*
   FROM BOOLTBL1
   WHERE f1 = 'true'::bool;
-----------------------------
| t_3         | f1          |
-----------------------------
|             | t           |
-----------------------------
|             | t           |
-----------------------------
|             | t           |
-----------------------------
QUERY: SELECT '' AS t_3, BOOLTBL1.*
   FROM BOOLTBL1
   WHERE f1 <> 'false'::bool;
-----------------------------
| t_3         | f1          |
-----------------------------
|             | t           |
-----------------------------
|             | t           |
-----------------------------
|             | t           |
-----------------------------
QUERY: SELECT '' AS zero, BOOLTBL1.*
   FROM BOOLTBL1
   WHERE booleq('false'::bool, f1);
-----------------------------
| zero        | f1          |
-----------------------------
QUERY: INSERT INTO BOOLTBL1 (f1) VALUES ('f'::bool);
QUERY: SELECT '' AS f_1, BOOLTBL1.*
   FROM BOOLTBL1
   WHERE f1 = 'false'::bool;
-----------------------------
| f_1         | f1          |
-----------------------------
|             | f           |
-----------------------------
QUERY: CREATE TABLE BOOLTBL2 (f1 bool);
QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('f'::bool);
QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('false'::bool);
QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('False'::bool);
QUERY: INSERT INTO BOOLTBL2 (f1)
   VALUES ('XXX'::bool);
QUERY: SELECT '' AS f_4, BOOLTBL2.*;
-----------------------------
| f_4         | f1          |
-----------------------------
|             | f           |
-----------------------------
|             | f           |
-----------------------------
|             | f           |
-----------------------------
|             | f           |
-----------------------------
QUERY: SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.*
   WHERE BOOLTBL2.f1 <> BOOLTBL1.f1;
-------------------------------------------
| tf_12       | f1          | f1          |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
QUERY: SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.*
   WHERE boolne(BOOLTBL2.f1,BOOLTBL1.f1);
-------------------------------------------
| tf_12       | f1          | f1          |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
QUERY: SELECT '' AS ff_4, BOOLTBL1.*, BOOLTBL2.*
   WHERE BOOLTBL2.f1 = BOOLTBL1.f1 and BOOLTBL1.f1 = 'false'::bool;
-------------------------------------------
| ff_4        | f1          | f1          |
-------------------------------------------
|             | f           | f           |
-------------------------------------------
|             | f           | f           |
-------------------------------------------
|             | f           | f           |
-------------------------------------------
|             | f           | f           |
-------------------------------------------
QUERY: SELECT '' AS tf_12_ff_4, BOOLTBL1.*, BOOLTBL2.*
   WHERE BOOLTBL2.f1 = BOOLTBL1.f1 or BOOLTBL1.f1 = 'true'::bool;
-------------------------------------------
| tf_12_ff_4  | f1          | f1          |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | f           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | f           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | f           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | t           | f           |
-------------------------------------------
|             | f           | f           |
-------------------------------------------
QUERY: CREATE TABLE ABSTIME_TBL (f1 abstime);
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Jan 14, 1973 03:14:21');
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Mon May  1 00:30:30 PDT 1995'::abstime);
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('epoch'::abstime);
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('current'::abstime);
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('infinity'::abstime);
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('-infinity'::abstime);
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('May 10, 1943 23:59:12');
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Feb 35, 1946 10:00:00');
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Feb 28, 1984 25:08:10');
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('bad date format');
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Jun 10, 1843');
QUERY: CREATE TABLE RELTIME_TBL (f1 reltime);
QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 1 minute');
QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 5 hour');
QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 10 day');
QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 34 year');
QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 3 months');
QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 14 seconds ago');
QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('badly formatted reltime');
QUERY: INSERT INTO RELTIME_TBL (f1) VALUES ('@ 30 eons ago');
QUERY: CREATE TABLE TINTERVAL_TBL (f1  tinterval);
QUERY: INSERT INTO TINTERVAL_TBL (f1)
   VALUES ('["-infinity" "infinity"]');
QUERY: INSERT INTO TINTERVAL_TBL (f1)
   VALUES ('["May 10, 1943 23:59:12" "Jan 14, 1973 03:14:21"]');
QUERY: INSERT INTO TINTERVAL_TBL (f1)
   VALUES ('["Sep 4, 1983 23:59:12" "Oct 4, 1983 23:59:12"]');
QUERY: INSERT INTO TINTERVAL_TBL (f1)
   VALUES ('["epoch" "Mon May  1 00:30:30 PDT 1995"]');
QUERY: INSERT INTO TINTERVAL_TBL (f1)
   VALUES ('["Feb 15 1990 12:15:03" "current"]');
QUERY: INSERT INTO TINTERVAL_TBL (f1)
   VALUES ('["bad time specifications" ""]');
QUERY: INSERT INTO TINTERVAL_TBL (f1)
   VALUES ('["" "infinity"]');
QUERY: SELECT '' AS eleven, ABSTIME_TBL.*;
-----------------------------
| eleven      | f1          |
-----------------------------
|             | Sun Jan 14 03:14:21 1973 PST|
-----------------------------
|             | Mon May 01 00:30:30 1995 PDT|
-----------------------------
|             | epoch       |
-----------------------------
|             | current     |
-----------------------------
|             | infinity    |
-----------------------------
|             | -infinity   |
-----------------------------
|             | Mon May 10 23:59:12 1943 PWT|
-----------------------------
|             | Thu Mar 07 10:00:00 1946 PST|
-----------------------------
|             | Wed Dec 31 15:59:59 1969 PST|
-----------------------------
|             | Invalid Abstime|
-----------------------------
|             | Invalid Abstime|
-----------------------------
QUERY: SELECT '' AS eight, ABSTIME_TBL.*
   WHERE ABSTIME_TBL.f1 < 'Jun 30, 2001'::abstime;
-----------------------------
| eight       | f1          |
-----------------------------
|             | Sun Jan 14 03:14:21 1973 PST|
-----------------------------
|             | Mon May 01 00:30:30 1995 PDT|
-----------------------------
|             | epoch       |
-----------------------------
|             | current     |
-----------------------------
|             | -infinity   |
-----------------------------
|             | Mon May 10 23:59:12 1943 PWT|
-----------------------------
|             | Thu Mar 07 10:00:00 1946 PST|
-----------------------------
|             | Wed Dec 31 15:59:59 1969 PST|
-----------------------------
QUERY: SELECT '' AS eight, ABSTIME_TBL.*
   WHERE ABSTIME_TBL.f1 > '-infinity'::abstime;
-----------------------------
| eight       | f1          |
-----------------------------
|             | Sun Jan 14 03:14:21 1973 PST|
-----------------------------
|             | Mon May 01 00:30:30 1995 PDT|
-----------------------------
|             | epoch       |
-----------------------------
|             | current     |
-----------------------------
|             | infinity    |
-----------------------------
|             | Mon May 10 23:59:12 1943 PWT|
-----------------------------
|             | Thu Mar 07 10:00:00 1946 PST|
-----------------------------
|             | Wed Dec 31 15:59:59 1969 PST|
-----------------------------
QUERY: SELECT '' AS eight, ABSTIME_TBL.*
   WHERE 'May 10, 1943 23:59:12'::abstime <> ABSTIME_TBL.f1;
-----------------------------
| eight       | f1          |
-----------------------------
|             | Sun Jan 14 03:14:21 1973 PST|
-----------------------------
|             | Mon May 01 00:30:30 1995 PDT|
-----------------------------
|             | epoch       |
-----------------------------
|             | current     |
-----------------------------
|             | infinity    |
-----------------------------
|             | -infinity   |
-----------------------------
|             | Thu Mar 07 10:00:00 1946 PST|
-----------------------------
|             | Wed Dec 31 15:59:59 1969 PST|
-----------------------------
QUERY: SELECT '' AS one, ABSTIME_TBL.*
   WHERE 'current'::abstime = ABSTIME_TBL.f1;
-----------------------------
| one         | f1          |
-----------------------------
|             | current     |
-----------------------------
QUERY: SELECT '' AS five, ABSTIME_TBL.*
   WHERE 'epoch'::abstime >= ABSTIME_TBL.f1;
-----------------------------
| five        | f1          |
-----------------------------
|             | epoch       |
-----------------------------
|             | -infinity   |
-----------------------------
|             | Mon May 10 23:59:12 1943 PWT|
-----------------------------
|             | Thu Mar 07 10:00:00 1946 PST|
-----------------------------
|             | Wed Dec 31 15:59:59 1969 PST|
-----------------------------
QUERY: SELECT '' AS six, ABSTIME_TBL.*
   WHERE ABSTIME_TBL.f1 <= 'Jan 14, 1973 03:14:21'::abstime;
-----------------------------
| six         | f1          |
-----------------------------
|             | Sun Jan 14 03:14:21 1973 PST|
-----------------------------
|             | epoch       |
-----------------------------
|             | -infinity   |
-----------------------------
|             | Mon May 10 23:59:12 1943 PWT|
-----------------------------
|             | Thu Mar 07 10:00:00 1946 PST|
-----------------------------
|             | Wed Dec 31 15:59:59 1969 PST|
-----------------------------
QUERY: SELECT '' AS six, ABSTIME_TBL.*
  WHERE ABSTIME_TBL.f1 <?>
	'["Apr 1 1945 00:00:00" "Dec 30 1999 23:00:00"]'::tinterval;
-----------------------------
| six         | f1          |
-----------------------------
|             | Sun Jan 14 03:14:21 1973 PST|
-----------------------------
|             | Mon May 01 00:30:30 1995 PDT|
-----------------------------
|             | epoch       |
-----------------------------
|             | current     |
-----------------------------
|             | Thu Mar 07 10:00:00 1946 PST|
-----------------------------
|             | Wed Dec 31 15:59:59 1969 PST|
-----------------------------
QUERY: SELECT '' AS five, ABSTIME_TBL.*
  WHERE  (ABSTIME_TBL.f1 + '@ 3 year'::reltime)     -- +3 years
	< 'Jan 14 14:00:00 1977'::abstime;
-----------------------------
| five        | f1          |
-----------------------------
|             | Sun Jan 14 03:14:21 1973 PST|
-----------------------------
|             | epoch       |
-----------------------------
|             | Mon May 10 23:59:12 1943 PWT|
-----------------------------
|             | Thu Mar 07 10:00:00 1946 PST|
-----------------------------
|             | Wed Dec 31 15:59:59 1969 PST|
-----------------------------
QUERY: SELECT '' AS five, ABSTIME_TBL.*
   WHERE  (ABSTIME_TBL.f1 + '@ 3 year ago'::reltime) -- -3 years
	< 'Jan 14 14:00:00 1971'::abstime;
-----------------------------
| five        | f1          |
-----------------------------
|             | Sun Jan 14 03:14:21 1973 PST|
-----------------------------
|             | epoch       |
-----------------------------
|             | Mon May 10 23:59:12 1943 PWT|
-----------------------------
|             | Thu Mar 07 10:00:00 1946 PST|
-----------------------------
|             | Wed Dec 31 15:59:59 1969 PST|
-----------------------------
QUERY: SELECT '' AS five, ABSTIME_TBL.*
   WHERE  (ABSTIME_TBL.f1 - '@ 3 year'::reltime)     -- -(+3) years
	< 'Jan 14 14:00:00 1971'::abstime;
-----------------------------
| five        | f1          |
-----------------------------
|             | Sun Jan 14 03:14:21 1973 PST|
-----------------------------
|             | epoch       |
-----------------------------
|             | Mon May 10 23:59:12 1943 PWT|
-----------------------------
|             | Thu Mar 07 10:00:00 1946 PST|
-----------------------------
|             | Wed Dec 31 15:59:59 1969 PST|
-----------------------------
QUERY: SELECT '' AS five, ABSTIME_TBL.*
   WHERE  (ABSTIME_TBL.f1 - '@ 3 year ago'::reltime) -- -(-3) years
	< 'Jan 14 14:00:00 1977'::abstime;
-----------------------------
| five        | f1          |
-----------------------------
|             | Sun Jan 14 03:14:21 1973 PST|
-----------------------------
|             | epoch       |
-----------------------------
|             | Mon May 10 23:59:12 1943 PWT|
-----------------------------
|             | Thu Mar 07 10:00:00 1946 PST|
-----------------------------
|             | Wed Dec 31 15:59:59 1969 PST|
-----------------------------
QUERY: SELECT '' AS twenty, ABSTIME_TBL.*, RELTIME_TBL.*
   WHERE (ABSTIME_TBL.f1 + RELTIME_TBL.f1)
	< 'Jan 14 14:00:00 1971'::abstime;
-------------------------------------------
| twenty      | f1          | f1          |
-------------------------------------------
|             | epoch       | @ 1 minute  |
-------------------------------------------
|             | Mon May 10 23:59:12 1943 PWT| @ 1 minute  |
-------------------------------------------
|             | Thu Mar 07 10:00:00 1946 PST| @ 1 minute  |
-------------------------------------------
|             | Wed Dec 31 15:59:59 1969 PST| @ 1 minute  |
-------------------------------------------
|             | epoch       | @ 5 hours   |
-------------------------------------------
|             | Mon May 10 23:59:12 1943 PWT| @ 5 hours   |
-------------------------------------------
|             | Thu Mar 07 10:00:00 1946 PST| @ 5 hours   |
-------------------------------------------
|             | Wed Dec 31 15:59:59 1969 PST| @ 5 hours   |
-------------------------------------------
|             | epoch       | @ 10 days   |
-------------------------------------------
|             | Mon May 10 23:59:12 1943 PWT| @ 10 days   |
-------------------------------------------
|             | Thu Mar 07 10:00:00 1946 PST| @ 10 days   |
-------------------------------------------
|             | Wed Dec 31 15:59:59 1969 PST| @ 10 days   |
-------------------------------------------
|             | epoch       | @ 3 months  |
-------------------------------------------
|             | Mon May 10 23:59:12 1943 PWT| @ 3 months  |
-------------------------------------------
|             | Thu Mar 07 10:00:00 1946 PST| @ 3 months  |
-------------------------------------------
|             | Wed Dec 31 15:59:59 1969 PST| @ 3 months  |
-------------------------------------------
|             | epoch       | @ 14 seconds ago|
-------------------------------------------
|             | Mon May 10 23:59:12 1943 PWT| @ 14 seconds ago|
-------------------------------------------
|             | Thu Mar 07 10:00:00 1946 PST| @ 14 seconds ago|
-------------------------------------------
|             | Wed Dec 31 15:59:59 1969 PST| @ 14 seconds ago|
-------------------------------------------
QUERY: SELECT '' AS eight, RELTIME_TBL.*;
-----------------------------
| eight       | f1          |
-----------------------------
|             | @ 1 minute  |
-----------------------------
|             | @ 5 hours   |
-----------------------------
|             | @ 10 days   |
-----------------------------
|             | @ 34 years  |
-----------------------------
|             | @ 3 months  |
-----------------------------
|             | @ 14 seconds ago|
-----------------------------
|             | Undefined RelTime|
-----------------------------
|             | Undefined RelTime|
-----------------------------
QUERY: SELECT '' AS five, RELTIME_TBL.*
   WHERE RELTIME_TBL.f1 <> '@ 10 days'::reltime;
-----------------------------
| five        | f1          |
-----------------------------
|             | @ 1 minute  |
-----------------------------
|             | @ 5 hours   |
-----------------------------
|             | @ 34 years  |
-----------------------------
|             | @ 3 months  |
-----------------------------
|             | @ 14 seconds ago|
-----------------------------
QUERY: SELECT '' AS three, RELTIME_TBL.*
   WHERE RELTIME_TBL.f1 <= '@ 5 hours'::reltime;
-----------------------------
| three       | f1          |
-----------------------------
|             | @ 1 minute  |
-----------------------------
|             | @ 5 hours   |
-----------------------------
|             | @ 14 seconds ago|
-----------------------------
QUERY: SELECT '' AS three, RELTIME_TBL.*
   WHERE RELTIME_TBL.f1 < '@ 1 day'::reltime;
-----------------------------
| three       | f1          |
-----------------------------
|             | @ 1 minute  |
-----------------------------
|             | @ 5 hours   |
-----------------------------
|             | @ 14 seconds ago|
-----------------------------
QUERY: SELECT '' AS one, RELTIME_TBL.*
   WHERE RELTIME_TBL.f1 = '@ 34 years'::reltime;
-----------------------------
| one         | f1          |
-----------------------------
|             | @ 34 years  |
-----------------------------
QUERY: SELECT '' AS two, RELTIME_TBL.*
   WHERE RELTIME_TBL.f1 >= '@ 1 month'::reltime;
-----------------------------
| two         | f1          |
-----------------------------
|             | @ 34 years  |
-----------------------------
|             | @ 3 months  |
-----------------------------
QUERY: SELECT '' AS five, RELTIME_TBL.*
   WHERE RELTIME_TBL.f1 > '@ 3 seconds ago'::reltime;
-----------------------------
| five        | f1          |
-----------------------------
|             | @ 1 minute  |
-----------------------------
|             | @ 5 hours   |
-----------------------------
|             | @ 10 days   |
-----------------------------
|             | @ 34 years  |
-----------------------------
|             | @ 3 months  |
-----------------------------
QUERY: SELECT '' AS fifteen, r1.*, r2.*
   FROM RELTIME_TBL r1, RELTIME_TBL r2
   WHERE r1.f1 > r2.f1;
-------------------------------------------
| fifteen     | f1          | f1          |
-------------------------------------------
|             | @ 5 hours   | @ 1 minute  |
-------------------------------------------
|             | @ 10 days   | @ 1 minute  |
-------------------------------------------
|             | @ 34 years  | @ 1 minute  |
-------------------------------------------
|             | @ 3 months  | @ 1 minute  |
-------------------------------------------
|             | @ 10 days   | @ 5 hours   |
-------------------------------------------
|             | @ 34 years  | @ 5 hours   |
-------------------------------------------
|             | @ 3 months  | @ 5 hours   |
-------------------------------------------
|             | @ 34 years  | @ 10 days   |
-------------------------------------------
|             | @ 3 months  | @ 10 days   |
-------------------------------------------
|             | @ 34 years  | @ 3 months  |
-------------------------------------------
|             | @ 1 minute  | @ 14 seconds ago|
-------------------------------------------
|             | @ 5 hours   | @ 14 seconds ago|
-------------------------------------------
|             | @ 10 days   | @ 14 seconds ago|
-------------------------------------------
|             | @ 34 years  | @ 14 seconds ago|
-------------------------------------------
|             | @ 3 months  | @ 14 seconds ago|
-------------------------------------------
QUERY: SELECT '' AS seven, TINTERVAL_TBL.*;
-----------------------------
| seven       | f1          |
-----------------------------
|             | ['-infinity' 'infinity']|
-----------------------------
|             | ['Mon May 10 23:59:12 1943 PWT' 'Sun Jan 14 03:14:21 1973 PST']|
-----------------------------
|             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
-----------------------------
|             | ['epoch' 'Mon May 01 00:30:30 1995 PDT']|
-----------------------------
|             | ['Thu Feb 15 12:15:03 1990 PST' 'current']|
-----------------------------
|             | ['Undefined Range']|
-----------------------------
|             | ['Undefined Range']|
-----------------------------
QUERY: SELECT '' AS one, t.*
   FROM TINTERVAL_TBL t
   WHERE t.f1 #= '@ 1 months';
-----------------------------
| one         | f1          |
-----------------------------
|             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
-----------------------------
QUERY: SELECT '' AS three, t.*
   FROM TINTERVAL_TBL t
   WHERE t.f1 #<> '@ 1 months';
-----------------------------
| three       | f1          |
-----------------------------
|             | ['Mon May 10 23:59:12 1943 PWT' 'Sun Jan 14 03:14:21 1973 PST']|
-----------------------------
|             | ['epoch' 'Mon May 01 00:30:30 1995 PDT']|
-----------------------------
|             | ['Thu Feb 15 12:15:03 1990 PST' 'current']|
-----------------------------
QUERY: SELECT '' AS zero, t.*
   FROM TINTERVAL_TBL t
   WHERE t.f1 #< '@ 1 month';
-----------------------------
| zero        | f1          |
-----------------------------
QUERY: SELECT '' AS one, t.*
   FROM TINTERVAL_TBL t
   WHERE t.f1 #<= '@ 1 month';
-----------------------------
| one         | f1          |
-----------------------------
|             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
-----------------------------
QUERY: SELECT '' AS three, t.*
   FROM TINTERVAL_TBL t
   WHERE t.f1 #> '@ 1 year';
-----------------------------
| three       | f1          |
-----------------------------
|             | ['Mon May 10 23:59:12 1943 PWT' 'Sun Jan 14 03:14:21 1973 PST']|
-----------------------------
|             | ['epoch' 'Mon May 01 00:30:30 1995 PDT']|
-----------------------------
|             | ['Thu Feb 15 12:15:03 1990 PST' 'current']|
-----------------------------
QUERY: SELECT '' AS three, t.*
   FROM TINTERVAL_TBL t
   WHERE t.f1 #>= '@ 3 years';
-----------------------------
| three       | f1          |
-----------------------------
|             | ['Mon May 10 23:59:12 1943 PWT' 'Sun Jan 14 03:14:21 1973 PST']|
-----------------------------
|             | ['epoch' 'Mon May 01 00:30:30 1995 PDT']|
-----------------------------
|             | ['Thu Feb 15 12:15:03 1990 PST' 'current']|
-----------------------------
QUERY: SELECT '' AS three, t1.*
   FROM TINTERVAL_TBL t1
   WHERE t1.f1 &&
	'["Aug 15 14:23:19 1983" "Sep 16 14:23:19 1983"]'::tinterval;
-----------------------------
| three       | f1          |
-----------------------------
|             | ['-infinity' 'infinity']|
-----------------------------
|             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
-----------------------------
|             | ['epoch' 'Mon May 01 00:30:30 1995 PDT']|
-----------------------------
QUERY: SELECT '' AS five, t1.*, t2.*
   FROM TINTERVAL_TBL t1, TINTERVAL_TBL t2
   WHERE t1.f1 && t2.f1 and
	 t1.f1 = t2.f1;
-------------------------------------------
| five        | f1          | f1          |
-------------------------------------------
|             | ['-infinity' 'infinity']| ['-infinity' 'infinity']|
-------------------------------------------
|             | ['Mon May 10 23:59:12 1943 PWT' 'Sun Jan 14 03:14:21 1973 PST']| ['Mon May 10 23:59:12 1943 PWT' 'Sun Jan 14 03:14:21 1973 PST']|
-------------------------------------------
|             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']| ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
-------------------------------------------
|             | ['epoch' 'Mon May 01 00:30:30 1995 PDT']| ['epoch' 'Mon May 01 00:30:30 1995 PDT']|
-------------------------------------------
|             | ['Thu Feb 15 12:15:03 1990 PST' 'current']| ['Thu Feb 15 12:15:03 1990 PST' 'current']|
-------------------------------------------
QUERY: SELECT '' AS fourteen, t1.*, t2.*
   FROM TINTERVAL_TBL t1, TINTERVAL_TBL t2
   WHERE t1.f1 && t2.f1 and
	not t1.f1 = t2.f1;
-------------------------------------------
| fourteen    | f1          | f1          |
-------------------------------------------
|             | ['Mon May 10 23:59:12 1943 PWT' 'Sun Jan 14 03:14:21 1973 PST']| ['-infinity' 'infinity']|
-------------------------------------------
|             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']| ['-infinity' 'infinity']|
-------------------------------------------
|             | ['epoch' 'Mon May 01 00:30:30 1995 PDT']| ['-infinity' 'infinity']|
-------------------------------------------
|             | ['Thu Feb 15 12:15:03 1990 PST' 'current']| ['-infinity' 'infinity']|
-------------------------------------------
|             | ['-infinity' 'infinity']| ['Mon May 10 23:59:12 1943 PWT' 'Sun Jan 14 03:14:21 1973 PST']|
-------------------------------------------
|             | ['epoch' 'Mon May 01 00:30:30 1995 PDT']| ['Mon May 10 23:59:12 1943 PWT' 'Sun Jan 14 03:14:21 1973 PST']|
-------------------------------------------
|             | ['-infinity' 'infinity']| ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
-------------------------------------------
|             | ['epoch' 'Mon May 01 00:30:30 1995 PDT']| ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
-------------------------------------------
|             | ['-infinity' 'infinity']| ['epoch' 'Mon May 01 00:30:30 1995 PDT']|
-------------------------------------------
|             | ['Mon May 10 23:59:12 1943 PWT' 'Sun Jan 14 03:14:21 1973 PST']| ['epoch' 'Mon May 01 00:30:30 1995 PDT']|
-------------------------------------------
|             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']| ['epoch' 'Mon May 01 00:30:30 1995 PDT']|
-------------------------------------------
|             | ['Thu Feb 15 12:15:03 1990 PST' 'current']| ['epoch' 'Mon May 01 00:30:30 1995 PDT']|
-------------------------------------------
|             | ['-infinity' 'infinity']| ['Thu Feb 15 12:15:03 1990 PST' 'current']|
-------------------------------------------
|             | ['epoch' 'Mon May 01 00:30:30 1995 PDT']| ['Thu Feb 15 12:15:03 1990 PST' 'current']|
-------------------------------------------
QUERY: SELECT '' AS five, t1.*
   FROM TINTERVAL_TBL t1
   WHERE not t1.f1 <<
	'["Aug 15 14:23:19 1980" "Sep 16 14:23:19 1990"]'::tinterval;
-----------------------------
| five        | f1          |
-----------------------------
|             | ['Mon May 10 23:59:12 1943 PWT' 'Sun Jan 14 03:14:21 1973 PST']|
-----------------------------
|             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
-----------------------------
|             | ['Thu Feb 15 12:15:03 1990 PST' 'current']|
-----------------------------
|             | ['Undefined Range']|
-----------------------------
|             | ['Undefined Range']|
-----------------------------
QUERY: SELECT '' AS three, t1.*
   FROM TINTERVAL_TBL t1
   WHERE t1.f1 &&
	('Aug 15 14:23:19 1983'::abstime <#>
	 'Sep 16 14:23:19 1983'::abstime);
-----------------------------
| three       | f1          |
-----------------------------
|             | ['-infinity' 'infinity']|
-----------------------------
|             | ['Sun Sep 04 23:59:12 1983 PDT' 'Tue Oct 04 23:59:12 1983 PDT']|
-----------------------------
|             | ['epoch' 'Mon May 01 00:30:30 1995 PDT']|
-----------------------------
QUERY: CREATE TABLE BOX_TBL (f1 box);
QUERY: INSERT INTO BOX_TBL (f1) VALUES ('(2.0,2.0,0.0,0.0)');
QUERY: INSERT INTO BOX_TBL (f1) VALUES ('(1.0,1.0,3.0,3.0)');
QUERY: INSERT INTO BOX_TBL (f1) VALUES ('(2.5, 2.5, 2.5,3.5)');
QUERY: INSERT INTO BOX_TBL (f1) VALUES ('(3.0, 3.0,3.0,3.0)');
QUERY: INSERT INTO BOX_TBL (f1) VALUES ('(2.3, 4.5)');
WARN:Bad box external representation '(2.3, 4.5)'
QUERY: INSERT INTO BOX_TBL (f1) VALUES ('asdfasdf(ad');
WARN:Bad box external representation 'asdfasdf(ad'
QUERY: SELECT '' AS four, BOX_TBL.*;
-----------------------------
| four        | f1          |
-----------------------------
|             | (2,2,0,0)   |
-----------------------------
|             | (3,3,1,1)   |
-----------------------------
|             | (2.5,3.5,2.5,2.5)|
-----------------------------
|             | (3,3,3,3)   |
-----------------------------
QUERY: SELECT '' AS four, b.*, box_area(b.f1) as barea
   FROM BOX_TBL b;
-------------------------------------------
| four        | f1          | barea       |
-------------------------------------------
|             | (2,2,0,0)   | 4           |
-------------------------------------------
|             | (3,3,1,1)   | 4           |
-------------------------------------------
|             | (2.5,3.5,2.5,2.5)| 0           |
-------------------------------------------
|             | (3,3,3,3)   | 0           |
-------------------------------------------
QUERY: SELECT '' AS three, b.f1
   FROM BOX_TBL b
   WHERE b.f1 && '(2.5,2.5,1.0,1.0)'::box;
-----------------------------
| three       | f1          |
-----------------------------
|             | (2,2,0,0)   |
-----------------------------
|             | (3,3,1,1)   |
-----------------------------
|             | (2.5,3.5,2.5,2.5)|
-----------------------------
QUERY: SELECT '' AS two, b1.*
   FROM BOX_TBL b1
   WHERE b1.f1 &< '(2.0,2.0,2.5,2.5)'::box;
-----------------------------
| two         | f1          |
-----------------------------
|             | (2,2,0,0)   |
-----------------------------
|             | (2.5,3.5,2.5,2.5)|
-----------------------------
QUERY: SELECT '' AS two, b1.*
   FROM BOX_TBL b1
   WHERE b1.f1 &> '(2.0,2.0,2.5,2.5)'::box;
-----------------------------
| two         | f1          |
-----------------------------
|             | (2.5,3.5,2.5,2.5)|
-----------------------------
|             | (3,3,3,3)   |
-----------------------------
QUERY: SELECT '' AS two, b.f1
   FROM BOX_TBL b
   WHERE b.f1 << '(3.0,3.0,5.0,5.0)'::box;
-----------------------------
| two         | f1          |
-----------------------------
|             | (2,2,0,0)   |
-----------------------------
|             | (2.5,3.5,2.5,2.5)|
-----------------------------
QUERY: SELECT '' AS four, b.f1
   FROM BOX_TBL b
   WHERE b.f1 <= '(3.0,3.0,5.0,5.0)'::box;
-----------------------------
| four        | f1          |
-----------------------------
|             | (2,2,0,0)   |
-----------------------------
|             | (3,3,1,1)   |
-----------------------------
|             | (2.5,3.5,2.5,2.5)|
-----------------------------
|             | (3,3,3,3)   |
-----------------------------
QUERY: SELECT '' AS two, b.f1
   FROM BOX_TBL b
   WHERE b.f1 < '(3.0,3.0,5.0,5.0)'::box;
-----------------------------
| two         | f1          |
-----------------------------
|             | (2.5,3.5,2.5,2.5)|
-----------------------------
|             | (3,3,3,3)   |
-----------------------------
QUERY: SELECT '' AS two, b.f1
   FROM BOX_TBL b
   WHERE b.f1 = '(3.0,3.0,5.0,5.0)'::box;
-----------------------------
| two         | f1          |
-----------------------------
|             | (2,2,0,0)   |
-----------------------------
|             | (3,3,1,1)   |
-----------------------------
QUERY: SELECT '' AS two, b.f1
   FROM BOX_TBL b				-- zero area
   WHERE b.f1 > '(3.5,3.0,4.5,3.0)'::box;
-----------------------------
| two         | f1          |
-----------------------------
|             | (2,2,0,0)   |
-----------------------------
|             | (3,3,1,1)   |
-----------------------------
QUERY: SELECT '' AS four, b.f1
   FROM BOX_TBL b				-- zero area
   WHERE b.f1 >= '(3.5,3.0,4.5,3.0)'::box;
-----------------------------
| four        | f1          |
-----------------------------
|             | (2,2,0,0)   |
-----------------------------
|             | (3,3,1,1)   |
-----------------------------
|             | (2.5,3.5,2.5,2.5)|
-----------------------------
|             | (3,3,3,3)   |
-----------------------------
QUERY: SELECT '' AS two, b.f1
   FROM BOX_TBL b
   WHERE '(3.0,3.0,5.0,5.0)'::box >> b.f1;
-----------------------------
| two         | f1          |
-----------------------------
|             | (2,2,0,0)   |
-----------------------------
|             | (2.5,3.5,2.5,2.5)|
-----------------------------
QUERY: SELECT '' AS three, b.f1
   FROM BOX_TBL b
   WHERE b.f1 @ '(0,0,3,3)'::box;
-----------------------------
| three       | f1          |
-----------------------------
|             | (2,2,0,0)   |
-----------------------------
|             | (3,3,1,1)   |
-----------------------------
|             | (3,3,3,3)   |
-----------------------------
QUERY: SELECT '' AS three, b.f1
   FROM BOX_TBL b
   WHERE '(0,0,3,3)'::box ~ b.f1;
-----------------------------
| three       | f1          |
-----------------------------
|             | (2,2,0,0)   |
-----------------------------
|             | (3,3,1,1)   |
-----------------------------
|             | (3,3,3,3)   |
-----------------------------
QUERY: SELECT '' AS one, b.f1
   FROM BOX_TBL b
   WHERE '(1,1,3,3)'::box ~= b.f1;
-----------------------------
| one         | f1          |
-----------------------------
|             | (3,3,1,1)   |
-----------------------------
QUERY: SELECT '' AS four, @@(b1.f1) AS p
   FROM BOX_TBL b1;
-----------------------------
| four        | p           |
-----------------------------
|             | (1,1)       |
-----------------------------
|             | (2,2)       |
-----------------------------
|             | (2.5,3)     |
-----------------------------
|             | (3,3)       |
-----------------------------
QUERY: SELECT '' AS one, b1.*, b2.*
   FROM BOX_TBL b1, BOX_TBL b2
   WHERE b1.f1 ~ b2.f1 and not b1.f1 ~= b2.f1;
-------------------------------------------
| one         | f1          | f1          |
-------------------------------------------
|             | (3,3,1,1)   | (3,3,3,3)   |
-------------------------------------------
QUERY: CREATE TABLE CHAR_TBL(f1 char);
QUERY: INSERT INTO CHAR_TBL (f1) VALUES ('a');
QUERY: INSERT INTO CHAR_TBL (f1) VALUES ('A');
QUERY: INSERT INTO CHAR_TBL (f1) VALUES ('1');
QUERY: INSERT INTO CHAR_TBL (f1) VALUES (2);
QUERY: INSERT INTO CHAR_TBL (f1) VALUES ('3');
QUERY: INSERT INTO CHAR_TBL (f1) VALUES ('');
QUERY: INSERT INTO CHAR_TBL (f1) VALUES ('cd');
QUERY: SELECT '' AS seven, CHAR_TBL.*;
-----------------------------
| seven       | f1          |
-----------------------------
|             | a           |
-----------------------------
|             | A           |
-----------------------------
|             | 1           |
-----------------------------
|             | 2           |
-----------------------------
|             | 3           |
-----------------------------
|             |             |
-----------------------------
|             | c           |
-----------------------------
QUERY: SELECT '' AS six, c.*
   FROM CHAR_TBL c
   WHERE c.f1 <> 'a';
-----------------------------
| six         | f1          |
-----------------------------
|             | A           |
-----------------------------
|             | 1           |
-----------------------------
|             | 2           |
-----------------------------
|             | 3           |
-----------------------------
|             |             |
-----------------------------
|             | c           |
-----------------------------
QUERY: SELECT '' AS one, c.*
   FROM CHAR_TBL c
   WHERE c.f1 = 'a';
-----------------------------
| one         | f1          |
-----------------------------
|             | a           |
-----------------------------
QUERY: SELECT '' AS five, c.*
   FROM CHAR_TBL c
   WHERE c.f1 < 'a';
-----------------------------
| five        | f1          |
-----------------------------
|             | A           |
-----------------------------
|             | 1           |
-----------------------------
|             | 2           |
-----------------------------
|             | 3           |
-----------------------------
|             |             |
-----------------------------
QUERY: SELECT '' AS six, c.*
   FROM CHAR_TBL c
   WHERE c.f1 <= 'a';
-----------------------------
| six         | f1          |
-----------------------------
|             | a           |
-----------------------------
|             | A           |
-----------------------------
|             | 1           |
-----------------------------
|             | 2           |
-----------------------------
|             | 3           |
-----------------------------
|             |             |
-----------------------------
QUERY: SELECT '' AS one, c.*
   FROM CHAR_TBL c
   WHERE c.f1 > 'a';
-----------------------------
| one         | f1          |
-----------------------------
|             | c           |
-----------------------------
QUERY: SELECT '' AS two, c.*
   FROM CHAR_TBL c
   WHERE c.f1 >= 'a';
-----------------------------
| two         | f1          |
-----------------------------
|             | a           |
-----------------------------
|             | c           |
-----------------------------
QUERY: CREATE TABLE CHAR2_TBL(f1 char2);
QUERY: INSERT INTO CHAR2_TBL (f1) VALUES ('AB');
QUERY: INSERT INTO CHAR2_TBL (f1) VALUES ('ab');
QUERY: INSERT INTO CHAR2_TBL (f1) VALUES ('ZY');
QUERY: INSERT INTO CHAR2_TBL (f1) VALUES ('34');
QUERY: INSERT INTO CHAR2_TBL (f1) VALUES ('d');
QUERY: INSERT INTO CHAR2_TBL (f1) VALUES ('');
QUERY: INSERT INTO CHAR2_TBL (f1) VALUES ('12345');
QUERY: SELECT '' AS seven, CHAR2_TBL.*;
-----------------------------
| seven       | f1          |
-----------------------------
|             | AB          |
-----------------------------
|             | ab          |
-----------------------------
|             | ZY          |
-----------------------------
|             | 34          |
-----------------------------
|             | d           |
-----------------------------
|             |             |
-----------------------------
|             | 12          |
-----------------------------
QUERY: SELECT '' AS six, c.f1 FROM CHAR2_TBL c WHERE c.f1 <> 'AB';
-----------------------------
| six         | f1          |
-----------------------------
|             | ab          |
-----------------------------
|             | ZY          |
-----------------------------
|             | 34          |
-----------------------------
|             | d           |
-----------------------------
|             |             |
-----------------------------
|             | 12          |
-----------------------------
QUERY: SELECT '' AS one, c.f1 FROM CHAR2_TBL c WHERE c.f1 = 'AB';
-----------------------------
| one         | f1          |
-----------------------------
|             | AB          |
-----------------------------
QUERY: SELECT '' AS three, c.f1 FROM CHAR2_TBL c WHERE c.f1 < 'AB';
-----------------------------
| three       | f1          |
-----------------------------
|             | 34          |
-----------------------------
|             |             |
-----------------------------
|             | 12          |
-----------------------------
QUERY: SELECT '' AS four, c.f1 FROM CHAR2_TBL c WHERE c.f1 <= 'AB';
-----------------------------
| four        | f1          |
-----------------------------
|             | AB          |
-----------------------------
|             | 34          |
-----------------------------
|             |             |
-----------------------------
|             | 12          |
-----------------------------
QUERY: SELECT '' AS three, c.f1 FROM CHAR2_TBL c WHERE c.f1 > 'AB';
-----------------------------
| three       | f1          |
-----------------------------
|             | ab          |
-----------------------------
|             | ZY          |
-----------------------------
|             | d           |
-----------------------------
QUERY: SELECT '' AS four, c.f1 FROM CHAR2_TBL c WHERE c.f1 >= 'AB';
-----------------------------
| four        | f1          |
-----------------------------
|             | AB          |
-----------------------------
|             | ab          |
-----------------------------
|             | ZY          |
-----------------------------
|             | d           |
-----------------------------
QUERY: SELECT '' AS seven, c.f1 FROM CHAR2_TBL c WHERE c.f1 ~ '.*';
-----------------------------
| seven       | f1          |
-----------------------------
|             | AB          |
-----------------------------
|             | ab          |
-----------------------------
|             | ZY          |
-----------------------------
|             | 34          |
-----------------------------
|             | d           |
-----------------------------
|             |             |
-----------------------------
|             | 12          |
-----------------------------
QUERY: SELECT '' AS zero, c.f1 FROM CHAR2_TBL c WHERE c.f1 !~ '.*';
-----------------------------
| zero        | f1          |
-----------------------------
QUERY: SELECT '' AS one, c.f1 FROM CHAR2_TBL c WHERE c.f1 ~ '34';
-----------------------------
| one         | f1          |
-----------------------------
|             | 34          |
-----------------------------
QUERY: SELECT '' AS one, c.f1 FROM CHAR2_TBL c WHERE c.f1 ~ '3.*';
-----------------------------
| one         | f1          |
-----------------------------
|             | 34          |
-----------------------------
QUERY: CREATE TABLE CHAR4_TBL (f1  char4);
QUERY: INSERT INTO CHAR4_TBL(f1) VALUES ('ABCD');
QUERY: INSERT INTO CHAR4_TBL(f1) VALUES ('abcd');
QUERY: INSERT INTO CHAR4_TBL(f1) VALUES ('ZYWZ');
QUERY: INSERT INTO CHAR4_TBL(f1) VALUES ('343f');
QUERY: INSERT INTO CHAR4_TBL(f1) VALUES ('d34a');
QUERY: INSERT INTO CHAR4_TBL(f1) VALUES ('');
QUERY: INSERT INTO CHAR4_TBL(f1) VALUES ('12345678');
QUERY: SELECT '' AS seven, CHAR4_TBL.*;
-----------------------------
| seven       | f1          |
-----------------------------
|             | ABCD        |
-----------------------------
|             | abcd        |
-----------------------------
|             | ZYWZ        |
-----------------------------
|             | 343f        |
-----------------------------
|             | d34a        |
-----------------------------
|             |             |
-----------------------------
|             | 1234        |
-----------------------------
QUERY: SELECT '' AS six, c.f1 FROM CHAR4_TBL c WHERE c.f1 <> 'ABCD';
-----------------------------
| six         | f1          |
-----------------------------
|             | abcd        |
-----------------------------
|             | ZYWZ        |
-----------------------------
|             | 343f        |
-----------------------------
|             | d34a        |
-----------------------------
|             |             |
-----------------------------
|             | 1234        |
-----------------------------
QUERY: SELECT '' AS one, c.f1 FROM CHAR4_TBL c WHERE c.f1 = 'ABCD';
-----------------------------
| one         | f1          |
-----------------------------
|             | ABCD        |
-----------------------------
QUERY: SELECT '' AS three, c.f1 FROM CHAR4_TBL c WHERE c.f1 < 'ABCD';
-----------------------------
| three       | f1          |
-----------------------------
|             | 343f        |
-----------------------------
|             |             |
-----------------------------
|             | 1234        |
-----------------------------
QUERY: SELECT '' AS four, c.f1 FROM CHAR4_TBL c WHERE c.f1 <= 'ABCD';
-----------------------------
| four        | f1          |
-----------------------------
|             | ABCD        |
-----------------------------
|             | 343f        |
-----------------------------
|             |             |
-----------------------------
|             | 1234        |
-----------------------------
QUERY: SELECT '' AS three, c.f1 FROM CHAR4_TBL c WHERE c.f1 > 'ABCD';
-----------------------------
| three       | f1          |
-----------------------------
|             | abcd        |
-----------------------------
|             | ZYWZ        |
-----------------------------
|             | d34a        |
-----------------------------
QUERY: SELECT '' AS four, c.f1 FROM CHAR4_TBL c WHERE c.f1 >= 'ABCD';
-----------------------------
| four        | f1          |
-----------------------------
|             | ABCD        |
-----------------------------
|             | abcd        |
-----------------------------
|             | ZYWZ        |
-----------------------------
|             | d34a        |
-----------------------------
QUERY: SELECT '' AS seven, c.f1 FROM CHAR4_TBL c WHERE c.f1 ~ '.*';
-----------------------------
| seven       | f1          |
-----------------------------
|             | ABCD        |
-----------------------------
|             | abcd        |
-----------------------------
|             | ZYWZ        |
-----------------------------
|             | 343f        |
-----------------------------
|             | d34a        |
-----------------------------
|             |             |
-----------------------------
|             | 1234        |
-----------------------------
QUERY: SELECT '' AS zero, c.f1 FROM CHAR4_TBL c WHERE c.f1 !~ '.*';
-----------------------------
| zero        | f1          |
-----------------------------
QUERY: SELECT '' AS three, c.f1 FROM CHAR4_TBL c WHERE c.f1 ~ '.*34.*';
-----------------------------
| three       | f1          |
-----------------------------
|             | 343f        |
-----------------------------
|             | d34a        |
-----------------------------
|             | 1234        |
-----------------------------
QUERY: CREATE TABLE CHAR8_TBL(f1 char8);
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('ABCDEFGH');
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('abcdefgh');
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('ZYWZ410-');
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('343f%2a');
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('d34aas');
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('');
QUERY: INSERT INTO CHAR8_TBL(f1) VALUES ('1234567890');
QUERY: SELECT '' AS seven, CHAR8_TBL.*;
-----------------------------
| seven       | f1          |
-----------------------------
|             | ABCDEFGH    |
-----------------------------
|             | abcdefgh    |
-----------------------------
|             | ZYWZ410-    |
-----------------------------
|             | 343f%2a     |
-----------------------------
|             | d34aas      |
-----------------------------
|             |             |
-----------------------------
|             | 12345678    |
-----------------------------
QUERY: SELECT '' AS six, c.f1 FROM CHAR8_TBL c WHERE c.f1 <> 'ABCDEFGH';
-----------------------------
| six         | f1          |
-----------------------------
|             | abcdefgh    |
-----------------------------
|             | ZYWZ410-    |
-----------------------------
|             | 343f%2a     |
-----------------------------
|             | d34aas      |
-----------------------------
|             |             |
-----------------------------
|             | 12345678    |
-----------------------------
QUERY: SELECT '' AS one, c.f1 FROM CHAR8_TBL c WHERE c.f1 = 'ABCDEFGH';
-----------------------------
| one         | f1          |
-----------------------------
|             | ABCDEFGH    |
-----------------------------
QUERY: SELECT '' AS three, c.f1 FROM CHAR8_TBL c WHERE c.f1 < 'ABCDEFGH';
-----------------------------
| three       | f1          |
-----------------------------
|             | 343f%2a     |
-----------------------------
|             |             |
-----------------------------
|             | 12345678    |
-----------------------------
QUERY: SELECT '' AS four, c.f1 FROM CHAR8_TBL c WHERE c.f1 <= 'ABCDEFGH';
-----------------------------
| four        | f1          |
-----------------------------
|             | ABCDEFGH    |
-----------------------------
|             | 343f%2a     |
-----------------------------
|             |             |
-----------------------------
|             | 12345678    |
-----------------------------
QUERY: SELECT '' AS three, c.f1 FROM CHAR8_TBL c WHERE c.f1 > 'ABCDEFGH';
-----------------------------
| three       | f1          |
-----------------------------
|             | abcdefgh    |
-----------------------------
|             | ZYWZ410-    |
-----------------------------
|             | d34aas      |
-----------------------------
QUERY: SELECT '' AS four, c.f1 FROM CHAR8_TBL c WHERE c.f1 >= 'ABCDEFGH';
-----------------------------
| four        | f1          |
-----------------------------
|             | ABCDEFGH    |
-----------------------------
|             | abcdefgh    |
-----------------------------
|             | ZYWZ410-    |
-----------------------------
|             | d34aas      |
-----------------------------
QUERY: SELECT '' AS seven, c.f1 FROM CHAR8_TBL c WHERE c.f1 ~ '.*';
-----------------------------
| seven       | f1          |
-----------------------------
|             | ABCDEFGH    |
-----------------------------
|             | abcdefgh    |
-----------------------------
|             | ZYWZ410-    |
-----------------------------
|             | 343f%2a     |
-----------------------------
|             | d34aas      |
-----------------------------
|             |             |
-----------------------------
|             | 12345678    |
-----------------------------
QUERY: SELECT '' AS zero, c.f1 FROM CHAR8_TBL c WHERE c.f1 !~ '.*';
-----------------------------
| zero        | f1          |
-----------------------------
QUERY: SELECT '' AS four, c.f1 FROM CHAR8_TBL c WHERE c.f1 ~ '[0-9]';
-----------------------------
| four        | f1          |
-----------------------------
|             | ZYWZ410-    |
-----------------------------
|             | 343f%2a     |
-----------------------------
|             | d34aas      |
-----------------------------
|             | 12345678    |
-----------------------------
QUERY: SELECT '' AS three, c.f1 FROM CHAR8_TBL c WHERE c.f1 ~ '.*34.*';
-----------------------------
| three       | f1          |
-----------------------------
|             | 343f%2a     |
-----------------------------
|             | d34aas      |
-----------------------------
|             | 12345678    |
-----------------------------
QUERY: CREATE TABLE CHAR16_TBL(f1 char16);
QUERY: INSERT INTO CHAR16_TBL(f1) VALUES ('ABCDEFGHIJKLMNOP');
QUERY: INSERT INTO CHAR16_TBL(f1) VALUES ('abcdefghijklmnop');
QUERY: INSERT INTO CHAR16_TBL(f1) VALUES ('asdfghjkl;');
QUERY: INSERT INTO CHAR16_TBL(f1) VALUES ('343f%2a');
QUERY: INSERT INTO CHAR16_TBL(f1) VALUES ('d34aaasdf');
QUERY: INSERT INTO CHAR16_TBL(f1) VALUES ('');
QUERY: INSERT INTO CHAR16_TBL(f1) VALUES ('1234567890ABCDEFGHIJKLMNOPQRSTUV');
QUERY: SELECT '' AS seven, CHAR16_TBL.*;
-----------------------------
| seven       | f1          |
-----------------------------
|             | ABCDEFGHIJKLMNOP|
-----------------------------
|             | abcdefghijklmnop|
-----------------------------
|             | asdfghjkl;  |
-----------------------------
|             | 343f%2a     |
-----------------------------
|             | d34aaasdf   |
-----------------------------
|             |             |
-----------------------------
|             | 1234567890ABCDEF|
-----------------------------
QUERY: SELECT '' AS six, c.f1 FROM CHAR16_TBL c WHERE c.f1 <> 'ABCDEFGHIJKLMNOP';
-----------------------------
| six         | f1          |
-----------------------------
|             | abcdefghijklmnop|
-----------------------------
|             | asdfghjkl;  |
-----------------------------
|             | 343f%2a     |
-----------------------------
|             | d34aaasdf   |
-----------------------------
|             |             |
-----------------------------
|             | 1234567890ABCDEF|
-----------------------------
QUERY: SELECT '' AS one, c.f1 FROM CHAR16_TBL c WHERE c.f1 = 'ABCDEFGHIJKLMNOP';
-----------------------------
| one         | f1          |
-----------------------------
|             | ABCDEFGHIJKLMNOP|
-----------------------------
QUERY: SELECT '' AS three, c.f1 FROM CHAR16_TBL c WHERE c.f1 < 'ABCDEFGHIJKLMNOP';
-----------------------------
| three       | f1          |
-----------------------------
|             | 343f%2a     |
-----------------------------
|             |             |
-----------------------------
|             | 1234567890ABCDEF|
-----------------------------
QUERY: SELECT '' AS four, c.f1 FROM CHAR16_TBL c WHERE c.f1 <= 'ABCDEFGHIJKLMNOP';
-----------------------------
| four        | f1          |
-----------------------------
|             | ABCDEFGHIJKLMNOP|
-----------------------------
|             | 343f%2a     |
-----------------------------
|             |             |
-----------------------------
|             | 1234567890ABCDEF|
-----------------------------
QUERY: SELECT '' AS three, c.f1 FROM CHAR16_TBL c WHERE c.f1 > 'ABCDEFGHIJKLMNOP';
-----------------------------
| three       | f1          |
-----------------------------
|             | abcdefghijklmnop|
-----------------------------
|             | asdfghjkl;  |
-----------------------------
|             | d34aaasdf   |
-----------------------------
QUERY: SELECT '' AS four, c.f1 FROM CHAR16_TBL c WHERE c.f1 >= 'ABCDEFGHIJKLMNOP';
-----------------------------
| four        | f1          |
-----------------------------
|             | ABCDEFGHIJKLMNOP|
-----------------------------
|             | abcdefghijklmnop|
-----------------------------
|             | asdfghjkl;  |
-----------------------------
|             | d34aaasdf   |
-----------------------------
QUERY: SELECT '' AS seven, c.f1 FROM CHAR16_TBL c WHERE c.f1 ~ '.*';
-----------------------------
| seven       | f1          |
-----------------------------
|             | ABCDEFGHIJKLMNOP|
-----------------------------
|             | abcdefghijklmnop|
-----------------------------
|             | asdfghjkl;  |
-----------------------------
|             | 343f%2a     |
-----------------------------
|             | d34aaasdf   |
-----------------------------
|             |             |
-----------------------------
|             | 1234567890ABCDEF|
-----------------------------
QUERY: SELECT '' AS zero, c.f1 FROM CHAR16_TBL c WHERE c.f1 !~ '.*';
-----------------------------
| zero        | f1          |
-----------------------------
QUERY: SELECT '' AS three, c.f1 FROM CHAR16_TBL c WHERE c.f1 ~ '[0-9]';
-----------------------------
| three       | f1          |
-----------------------------
|             | 343f%2a     |
-----------------------------
|             | d34aaasdf   |
-----------------------------
|             | 1234567890ABCDEF|
-----------------------------
QUERY: SELECT '' AS two, c.f1 FROM CHAR16_TBL c WHERE c.f1 ~ '.*asdf.*';
-----------------------------
| two         | f1          |
-----------------------------
|             | 343f%2a     |
-----------------------------
|             | d34aaasdf   |
-----------------------------
|             | 1234567890ABCDEF|
-----------------------------
QUERY: CREATE TABLE FLOAT4_TBL (f1  float4);
QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('0.0');
QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('1004.30');
QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('-34.84');
QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('1.2345678901234e+20');
QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('1.2345678901234e-20');
QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('10e40');
WARN:	Bad float4 input format -- overflow

QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e40');
WARN:	Bad float4 input format -- overflow

QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('10e-40');
WARN:	Bad float4 input format -- underflow

QUERY: INSERT INTO FLOAT4_TBL(f1) VALUES ('-10e-40');
WARN:	Bad float4 input format -- underflow

QUERY: SELECT '' AS five, FLOAT4_TBL.*;
-----------------------------
| five        | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 1004.3      |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.23457e+20 |
-----------------------------
|             | 1.23457e-20 |
-----------------------------
QUERY: SELECT '' AS four, f.* FROM FLOAT4_TBL f WHERE f.f1 <> '1004.3';
-----------------------------
| four        | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.23457e+20 |
-----------------------------
|             | 1.23457e-20 |
-----------------------------
QUERY: SELECT '' AS one, f.* FROM FLOAT4_TBL f WHERE f.f1 = '1004.3';
-----------------------------
| one         | f1          |
-----------------------------
|             | 1004.3      |
-----------------------------
QUERY: SELECT '' AS three, f.* FROM FLOAT4_TBL f WHERE '1004.3' > f.f1;
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.23457e-20 |
-----------------------------
QUERY: SELECT '' AS three, f.* FROM FLOAT4_TBL f WHERE  f.f1 < '1004.3';
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.23457e-20 |
-----------------------------
QUERY: SELECT '' AS four, f.* FROM FLOAT4_TBL f WHERE '1004.3' >= f.f1;
-----------------------------
| four        | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 1004.3      |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.23457e-20 |
-----------------------------
QUERY: SELECT '' AS four, f.* FROM FLOAT4_TBL f WHERE  f.f1 <= '1004.3';
-----------------------------
| four        | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 1004.3      |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.23457e-20 |
-----------------------------
QUERY: SELECT '' AS three, f.f1, f.f1 * '-10' AS x FROM FLOAT4_TBL f
   WHERE f.f1 > '0.0';
-------------------------------------------
| three       | f1          | x           |
-------------------------------------------
|             | 1004.3      | -10043      |
-------------------------------------------
|             | 1.23457e+20 | -1.23457e+21|
-------------------------------------------
|             | 1.23457e-20 | -1.23457e-19|
-------------------------------------------
QUERY: SELECT '' AS three, f.f1, f.f1 + '-10' AS x FROM FLOAT4_TBL f
   WHERE f.f1 > '0.0'
SELECT '' AS three, f.f1, f.f1 / '-10' AS x FROM FLOAT4_TBL f
   WHERE f.f1 > '0.0';
-------------------------------------------
| three       | f1          | x           |
-------------------------------------------
|             | 1004.3      | 994.3       |
-------------------------------------------
|             | 1.23457e+20 | 1.23457e+20 |
-------------------------------------------
|             | 1.23457e-20 | -10         |
-------------------------------------------
QUERY: SELECT '' AS three, f.f1, f.f1 - '-10' AS x FROM FLOAT4_TBL f
   WHERE f.f1 > '0.0';
-------------------------------------------
| three       | f1          | x           |
-------------------------------------------
|             | 1004.3      | -100.43     |
-------------------------------------------
|             | 1.23457e+20 | -1.23457e+19|
-------------------------------------------
|             | 1.23457e-20 | -1.23457e-21|
-------------------------------------------
QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT4_TBL f;
-------------------------------------------
| three       | f1          | x           |
-------------------------------------------
|             | 1004.3      | 1014.3      |
-------------------------------------------
|             | 1.23457e+20 | 1.23457e+20 |
-------------------------------------------
|             | 1.23457e-20 | 10          |
-------------------------------------------
QUERY: SELECT '' AS five, FLOAT4_TBL.*;
WARN:float4div:  divide by 0.0 error
QUERY: SELECT '' AS five, f.f1, @f.f1 AS abs_f1 FROM FLOAT4_TBL f;
-----------------------------
| five        | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 1004.3      |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.23457e+20 |
-----------------------------
|             | 1.23457e-20 |
-----------------------------
QUERY: UPDATE FLOAT4_TBL
   SET f1 = FLOAT4_TBL.f1 * '-1'
   WHERE FLOAT4_TBL.f1 > '0.0';
-------------------------------------------
| five        | f1          | abs_f1      |
-------------------------------------------
|             | 0           | 0           |
-------------------------------------------
|             | 1004.3      | 1004.3      |
-------------------------------------------
|             | -34.84      | 34.84       |
-------------------------------------------
|             | 1.23457e+20 | 1.23457e+20 |
-------------------------------------------
|             | 1.23457e-20 | 1.23457e-20 |
-------------------------------------------
QUERY: SELECT '' AS five, FLOAT4_TBL.*;
QUERY: CREATE TABLE FLOAT8_TBL(f1 float8);
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('0.0');
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('1004.30');
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-34.84');
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e+200');
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-200');
QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
WARN:	Bad float8 input format

QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
WARN:	Bad float8 input format

QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
WARN:	Bad float8 input format

QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
WARN:	Bad float8 input format

QUERY: SELECT '' AS five, FLOAT8_TBL.*;
-----------------------------
| five        | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 1004.3      |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.2345678901234e+200|
-----------------------------
|             | 1.2345678901234e-200|
-----------------------------
QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3';
-----------------------------
| four        | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.2345678901234e+200|
-----------------------------
|             | 1.2345678901234e-200|
-----------------------------
QUERY: SELECT '' AS one, f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3';
-----------------------------
| one         | f1          |
-----------------------------
|             | 1004.3      |
-----------------------------
QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE '1004.3' > f.f1;
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.2345678901234e-200|
-----------------------------
QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE  f.f1 < '1004.3';
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.2345678901234e-200|
-----------------------------
QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1;
-----------------------------
| four        | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 1004.3      |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.2345678901234e-200|
-----------------------------
QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE  f.f1 <= '1004.3';
-----------------------------
| four        | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 1004.3      |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.2345678901234e-200|
-----------------------------
QUERY: SELECT '' AS three, f.f1, f.f1 * '-10' AS x
   FROM FLOAT8_TBL f
   WHERE f.f1 > '0.0';
-------------------------------------------
| three       | f1          | x           |
-------------------------------------------
|             | 1004.3      | -10043      |
-------------------------------------------
|             | 1.2345678901234e+200| -1.2345678901234e+201|
-------------------------------------------
|             | 1.2345678901234e-200| -1.2345678901234e-199|
-------------------------------------------
QUERY: SELECT '' AS three, f.f1, f.f1 + '-10' AS x
   FROM FLOAT8_TBL f
   WHERE f.f1 > '0.0';
-------------------------------------------
| three       | f1          | x           |
-------------------------------------------
|             | 1004.3      | 994.3       |
-------------------------------------------
|             | 1.2345678901234e+200| 1.2345678901234e+200|
-------------------------------------------
|             | 1.2345678901234e-200| -10         |
-------------------------------------------
QUERY: SELECT '' AS three, f.f1, f.f1 / '-10' AS x
   FROM FLOAT8_TBL f
   WHERE f.f1 > '0.0';
-------------------------------------------
| three       | f1          | x           |
-------------------------------------------
|             | 1004.3      | -100.43     |
-------------------------------------------
|             | 1.2345678901234e+200| -1.2345678901234e+199|
-------------------------------------------
|             | 1.2345678901234e-200| -1.2345678901234e-201|
-------------------------------------------
QUERY: SELECT '' AS three, f.f1, f.f1 - '-10' AS x
   FROM FLOAT8_TBL f
   WHERE f.f1 > '0.0';
-------------------------------------------
| three       | f1          | x           |
-------------------------------------------
|             | 1004.3      | 1014.3      |
-------------------------------------------
|             | 1.2345678901234e+200| 1.2345678901234e+200|
-------------------------------------------
|             | 1.2345678901234e-200| 10          |
-------------------------------------------
QUERY: SELECT '' AS one, f.f1 ^ '2.0' AS square_f1
   FROM FLOAT8_TBL f where f.f1 = '1004.3';
-----------------------------
| one         | square_f1   |
-----------------------------
|             | 1008618.49  |
-----------------------------
QUERY: SELECT '' AS five, f.f1, @f.f1 AS abs_f1
   FROM FLOAT8_TBL f;
-------------------------------------------
| five        | f1          | abs_f1      |
-------------------------------------------
|             | 0           | 0           |
-------------------------------------------
|             | 1004.3      | 1004.3      |
-------------------------------------------
|             | -34.84      | 34.84       |
-------------------------------------------
|             | 1.2345678901234e+200| 1.2345678901234e+200|
-------------------------------------------
|             | 1.2345678901234e-200| 1.2345678901234e-200|
-------------------------------------------
QUERY: SELECT '' AS five, f.f1, %f.f1 AS trunc_f1
   FROM FLOAT8_TBL f;
-------------------------------------------
| five        | f1          | trunc_f1    |
-------------------------------------------
|             | 0           | 0           |
-------------------------------------------
|             | 1004.3      | 1004        |
-------------------------------------------
|             | -34.84      | -34         |
-------------------------------------------
|             | 1.2345678901234e+200| 1.2345678901234e+200|
-------------------------------------------
|             | 1.2345678901234e-200| 0           |
-------------------------------------------
QUERY: SELECT '' AS five, f.f1, f.f1 % AS round_f1
   FROM FLOAT8_TBL f;
-------------------------------------------
| five        | f1          | round_f1    |
-------------------------------------------
|             | 0           | 0           |
-------------------------------------------
|             | 1004.3      | 1004        |
-------------------------------------------
|             | -34.84      | -35         |
-------------------------------------------
|             | 1.2345678901234e+200| 1.2345678901234e+200|
-------------------------------------------
|             | 1.2345678901234e-200| 0           |
-------------------------------------------
QUERY: SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
   FROM FLOAT8_TBL f
   WHERE f.f1 > '0.0';
-------------------------------------------
| three       | f1          | sqrt_f1     |
-------------------------------------------
|             | 1004.3      | 31.6906926399535|
-------------------------------------------
|             | 1.2345678901234e+200| 1.11111110611109e+100|
-------------------------------------------
|             | 1.2345678901234e-200| 1.11111110611109e-100|
-------------------------------------------
QUERY: SELECT '' AS three, f.f1, : ( ; f.f1) AS exp_ln_f1
   FROM FLOAT8_TBL f
   WHERE f.f1 > '0.0';
-------------------------------------------
| three       | f1          | exp_ln_f1   |
-------------------------------------------
|             | 1004.3      | 1004.3      |
-------------------------------------------
|             | 1.2345678901234e+200| 1.23456789012338e+200|
-------------------------------------------
|             | 1.2345678901234e-200| 1.23456789012339e-200|
-------------------------------------------
QUERY: SELECT '' AS five, f.f1, ||/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f;
-------------------------------------------
| five        | f1          | cbrt_f1     |
-------------------------------------------
|             | 0           | 0           |
-------------------------------------------
|             | 1004.3      | 10.014312837827|
-------------------------------------------
|             | -34.84      | -3.26607421344208|
-------------------------------------------
|             | 1.2345678901234e+200| 4.9793385923476e+66|
-------------------------------------------
|             | 1.2345678901234e-200| 2.31120424090182e-67|
-------------------------------------------
QUERY: SELECT '' AS five, FLOAT8_TBL.*;
-----------------------------
| five        | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 1004.3      |
-----------------------------
|             | -34.84      |
-----------------------------
|             | 1.2345678901234e+200|
-----------------------------
|             | 1.2345678901234e-200|
-----------------------------
QUERY: UPDATE FLOAT8_TBL
   SET f1 = FLOAT8_TBL.f1 * '-1'
   WHERE FLOAT8_TBL.f1 > '0.0';
QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
WARN:floating point exception! the last floating point operation either exceeded legal ranges or was a divide by zero
QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
WARN:floating point exception! the last floating point operation either exceeded legal ranges or was a divide by zero
QUERY: SELECT '' AS bad, ; (f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ;
WARN:can't take log of 0!
QUERY: SELECT '' AS bad, ; (f.f1) from FLOAT8_TBL f where f.f1 < '0.0' ;
WARN:can't take log of a negative number
QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f;
-----------------------------
| bad         | ?column?    |
-----------------------------
|             | 1           |
-----------------------------
|             | 7.39913613794055e-16|
-----------------------------
|             | 0           |
-----------------------------
|             | 0           |
-----------------------------
|             | 0.999999940395355|
-----------------------------
QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
WARN:float8div:  divide by 0.0 error
QUERY: SELECT '' AS five, FLOAT8_TBL.*;
-----------------------------
| five        | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | -34.84      |
-----------------------------
|             | -1004.3     |
-----------------------------
|             | -1.2345678901234e+200|
-----------------------------
|             | -1.2345678901234e-200|
-----------------------------
QUERY: CREATE TABLE INT2_TBL(f1 int2);
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('0');
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('1234');
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('-1234');
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('34.5');
WARN:pg_atoi: error in "34.5": can't parse ".5"
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('32767');
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('-32767');
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('100000');
WARN:pg_atoi: error reading "100000": Math result not representable
QUERY: INSERT INTO INT2_TBL(f1) VALUES ('asdf');
WARN:pg_atoi: error in "asdf": can't parse "asdf"
QUERY: SELECT '' AS five, INT2_TBL.*;
-----------------------------
| five        | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 1234        |
-----------------------------
|             | -1234       |
-----------------------------
|             | 32767       |
-----------------------------
|             | -32767      |
-----------------------------
QUERY: SELECT '' AS four, i.* FROM INT2_TBL i WHERE i.f1 <> '0'::int2;
-----------------------------
| four        | f1          |
-----------------------------
|             | 1234        |
-----------------------------
|             | -1234       |
-----------------------------
|             | 32767       |
-----------------------------
|             | -32767      |
-----------------------------
QUERY: SELECT '' AS four, i.* FROM INT2_TBL i WHERE i.f1 <> '0'::int4;
-----------------------------
| four        | f1          |
-----------------------------
|             | 1234        |
-----------------------------
|             | -1234       |
-----------------------------
|             | 32767       |
-----------------------------
|             | -32767      |
-----------------------------
QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE i.f1 = '0'::int2;
-----------------------------
| one         | f1          |
-----------------------------
|             | 0           |
-----------------------------
QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE i.f1 = '0'::int4;
-----------------------------
| one         | f1          |
-----------------------------
|             | 0           |
-----------------------------
QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 < '0'::int2;
-----------------------------
| two         | f1          |
-----------------------------
|             | -1234       |
-----------------------------
|             | -32767      |
-----------------------------
QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 < '0'::int4;
-----------------------------
| two         | f1          |
-----------------------------
|             | -1234       |
-----------------------------
|             | -32767      |
-----------------------------
QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 <= '0'::int2;
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | -1234       |
-----------------------------
|             | -32767      |
-----------------------------
QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 <= '0'::int4;
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | -1234       |
-----------------------------
|             | -32767      |
-----------------------------
QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 > '0'::int2;
-----------------------------
| two         | f1          |
-----------------------------
|             | 1234        |
-----------------------------
|             | 32767       |
-----------------------------
QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 > '0'::int4;
-----------------------------
| two         | f1          |
-----------------------------
|             | 1234        |
-----------------------------
|             | 32767       |
-----------------------------
QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 >= '0'::int2;
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 1234        |
-----------------------------
|             | 32767       |
-----------------------------
QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 >= '0'::int4;
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 1234        |
-----------------------------
|             | 32767       |
-----------------------------
QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE (i.f1 % '2'::int2) = '1'::int2;
-----------------------------
| one         | f1          |
-----------------------------
|             | 32767       |
-----------------------------
QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE (i.f1 % '2'::int4) = '0'::int2;
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 1234        |
-----------------------------
|             | -1234       |
-----------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int2 AS x FROM INT2_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | 0           |
-------------------------------------------
|             | 1234        | 2468        |
-------------------------------------------
|             | -1234       | -2468       |
-------------------------------------------
|             | 32767       | -2          |
-------------------------------------------
|             | -32767      | 2           |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int4 AS x FROM INT2_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | 0           |
-------------------------------------------
|             | 1234        | 2468        |
-------------------------------------------
|             | -1234       | -2468       |
-------------------------------------------
|             | 32767       | 65534       |
-------------------------------------------
|             | -32767      | -65534      |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int2 AS x FROM INT2_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | 2           |
-------------------------------------------
|             | 1234        | 1236        |
-------------------------------------------
|             | -1234       | -1232       |
-------------------------------------------
|             | 32767       | -32767      |
-------------------------------------------
|             | -32767      | -32765      |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int4 AS x FROM INT2_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | 2           |
-------------------------------------------
|             | 1234        | 1236        |
-------------------------------------------
|             | -1234       | -1232       |
-------------------------------------------
|             | 32767       | 32769       |
-------------------------------------------
|             | -32767      | -32765      |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int2 AS x FROM INT2_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | -2          |
-------------------------------------------
|             | 1234        | 1232        |
-------------------------------------------
|             | -1234       | -1236       |
-------------------------------------------
|             | 32767       | 32765       |
-------------------------------------------
|             | -32767      | 32767       |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int4 AS x FROM INT2_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | -2          |
-------------------------------------------
|             | 1234        | 1232        |
-------------------------------------------
|             | -1234       | -1236       |
-------------------------------------------
|             | 32767       | 32765       |
-------------------------------------------
|             | -32767      | -32769      |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int2 AS x FROM INT2_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | 0           |
-------------------------------------------
|             | 1234        | 617         |
-------------------------------------------
|             | -1234       | -617        |
-------------------------------------------
|             | 32767       | 16383       |
-------------------------------------------
|             | -32767      | -16383      |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int4 AS x FROM INT2_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | 0           |
-------------------------------------------
|             | 1234        | 617         |
-------------------------------------------
|             | -1234       | -617        |
-------------------------------------------
|             | 32767       | 16383       |
-------------------------------------------
|             | -32767      | -16383      |
-------------------------------------------
QUERY: CREATE TABLE INT4_TBL(f1 int4);
QUERY: INSERT INTO INT4_TBL(f1) VALUES ('0');
QUERY: INSERT INTO INT4_TBL(f1) VALUES ('123456');
QUERY: INSERT INTO INT4_TBL(f1) VALUES ('-123456');
QUERY: INSERT INTO INT4_TBL(f1) VALUES ('34.5');
WARN:pg_atoi: error in "34.5": can't parse ".5"
QUERY: INSERT INTO INT4_TBL(f1) VALUES ('2147483647');
QUERY: INSERT INTO INT4_TBL(f1) VALUES ('-2147483647');
QUERY: INSERT INTO INT4_TBL(f1) VALUES ('1000000000000');
WARN:pg_atoi: error reading "1000000000000": Math result not representable
QUERY: INSERT INTO INT4_TBL(f1) VALUES ('asdf');
WARN:pg_atoi: error in "asdf": can't parse "asdf"
QUERY: SELECT '' AS five, INT4_TBL.*;
-----------------------------
| five        | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 123456      |
-----------------------------
|             | -123456     |
-----------------------------
|             | 2147483647  |
-----------------------------
|             | -2147483647 |
-----------------------------
QUERY: SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> '0'::int2;
-----------------------------
| four        | f1          |
-----------------------------
|             | 123456      |
-----------------------------
|             | -123456     |
-----------------------------
|             | 2147483647  |
-----------------------------
|             | -2147483647 |
-----------------------------
QUERY: SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> '0'::int4;
-----------------------------
| four        | f1          |
-----------------------------
|             | 123456      |
-----------------------------
|             | -123456     |
-----------------------------
|             | 2147483647  |
-----------------------------
|             | -2147483647 |
-----------------------------
QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE i.f1 = '0'::int2;
-----------------------------
| one         | f1          |
-----------------------------
|             | 0           |
-----------------------------
QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE i.f1 = '0'::int4;
-----------------------------
| one         | f1          |
-----------------------------
|             | 0           |
-----------------------------
QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 < '0'::int2;
-----------------------------
| two         | f1          |
-----------------------------
|             | -123456     |
-----------------------------
|             | -2147483647 |
-----------------------------
QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 < '0'::int4;
-----------------------------
| two         | f1          |
-----------------------------
|             | -123456     |
-----------------------------
|             | -2147483647 |
-----------------------------
QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= '0'::int2;
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | -123456     |
-----------------------------
|             | -2147483647 |
-----------------------------
QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= '0'::int4;
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | -123456     |
-----------------------------
|             | -2147483647 |
-----------------------------
QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 > '0'::int2;
-----------------------------
| two         | f1          |
-----------------------------
|             | 123456      |
-----------------------------
|             | 2147483647  |
-----------------------------
QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 > '0'::int4;
-----------------------------
| two         | f1          |
-----------------------------
|             | 123456      |
-----------------------------
|             | 2147483647  |
-----------------------------
QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 >= '0'::int2;
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 123456      |
-----------------------------
|             | 2147483647  |
-----------------------------
QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 >= '0'::int4;
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 123456      |
-----------------------------
|             | 2147483647  |
-----------------------------
QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE (i.f1 % '2'::int2) = '1'::int2;
-----------------------------
| one         | f1          |
-----------------------------
|             | 2147483647  |
-----------------------------
QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE (i.f1 % '2'::int4) = '0'::int2;
-----------------------------
| three       | f1          |
-----------------------------
|             | 0           |
-----------------------------
|             | 123456      |
-----------------------------
|             | -123456     |
-----------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int2 AS x FROM INT4_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | 0           |
-------------------------------------------
|             | 123456      | 246912      |
-------------------------------------------
|             | -123456     | -246912     |
-------------------------------------------
|             | 2147483647  | -2          |
-------------------------------------------
|             | -2147483647 | 2           |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int4 AS x FROM INT4_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | 0           |
-------------------------------------------
|             | 123456      | 246912      |
-------------------------------------------
|             | -123456     | -246912     |
-------------------------------------------
|             | 2147483647  | -2          |
-------------------------------------------
|             | -2147483647 | 2           |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int2 AS x FROM INT4_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | 2           |
-------------------------------------------
|             | 123456      | 123458      |
-------------------------------------------
|             | -123456     | -123454     |
-------------------------------------------
|             | 2147483647  | -2147483647 |
-------------------------------------------
|             | -2147483647 | -2147483645 |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int4 AS x FROM INT4_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | 2           |
-------------------------------------------
|             | 123456      | 123458      |
-------------------------------------------
|             | -123456     | -123454     |
-------------------------------------------
|             | 2147483647  | -2147483647 |
-------------------------------------------
|             | -2147483647 | -2147483645 |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int2 AS x FROM INT4_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | -2          |
-------------------------------------------
|             | 123456      | 123454      |
-------------------------------------------
|             | -123456     | -123458     |
-------------------------------------------
|             | 2147483647  | 2147483645  |
-------------------------------------------
|             | -2147483647 | 2147483647  |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int4 AS x FROM INT4_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | -2          |
-------------------------------------------
|             | 123456      | 123454      |
-------------------------------------------
|             | -123456     | -123458     |
-------------------------------------------
|             | 2147483647  | 2147483645  |
-------------------------------------------
|             | -2147483647 | 2147483647  |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int2 AS x FROM INT4_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | 0           |
-------------------------------------------
|             | 123456      | 61728       |
-------------------------------------------
|             | -123456     | -61728      |
-------------------------------------------
|             | 2147483647  | 1073741823  |
-------------------------------------------
|             | -2147483647 | -1073741823 |
-------------------------------------------
QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int4 AS x FROM INT4_TBL i;
-------------------------------------------
| five        | f1          | x           |
-------------------------------------------
|             | 0           | 0           |
-------------------------------------------
|             | 123456      | 61728       |
-------------------------------------------
|             | -123456     | -61728      |
-------------------------------------------
|             | 2147483647  | 1073741823  |
-------------------------------------------
|             | -2147483647 | -1073741823 |
-------------------------------------------
QUERY: SELECT '2'::int2 * '2'::int2 = '16'::int2 / '4'::int2 AS true;
---------------
| true        |
---------------
| t           |
---------------
QUERY: SELECT '2'::int4 * '2'::int2 = '16'::int2 / '4'::int4 AS true;
---------------
| true        |
---------------
| t           |
---------------
QUERY: SELECT '2'::int2 * '2'::int4 = '16'::int4 / '4'::int2 AS true;
---------------
| true        |
---------------
| t           |
---------------
QUERY: SELECT '1000'::int4 < '999'::int4 AS false;
---------------
| false       |
---------------
| f           |
---------------
QUERY: SELECT 4! AS twenty_four;
---------------
| twenty_four |
---------------
| 24          |
---------------
QUERY: SELECT !!3 AS six;
---------------
| six         |
---------------
| 6           |
---------------
QUERY: SELECT 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 AS ten;
---------------
| ten         |
---------------
| 10          |
---------------
QUERY: SELECT 2 + 2 / 2 AS three;
---------------
| three       |
---------------
| 3           |
---------------
QUERY: SELECT (2 + 2) / 2 AS two;
---------------
| two         |
---------------
| 2           |
---------------
QUERY: SELECT dsqrt('64'::float8) AS eight;
---------------
| eight       |
---------------
| 8           |
---------------
QUERY: SELECT |/'64'::float8 AS eight;
---------------
| eight       |
---------------
| 8           |
---------------
QUERY: SELECT ||/'27'::float8 AS three;
---------------
| three       |
---------------
| 3           |
---------------
QUERY: CREATE TABLE OID_TBL(f1 oid);
QUERY: INSERT INTO OID_TBL(f1) VALUES ('1234');
QUERY: INSERT INTO OID_TBL(f1) VALUES ('1235');
QUERY: INSERT INTO OID_TBL(f1) VALUES ('987');
QUERY: INSERT INTO OID_TBL(f1) VALUES ('-1040');
QUERY: INSERT INTO OID_TBL(f1) VALUES ('');
QUERY: INSERT INTO OID_TBL(f1) VALUES ('asdfasd');
WARN:pg_atoi: error in "asdfasd": can't parse "asdfasd"
QUERY: SELECT '' AS five, OID_TBL.*;
-----------------------------
| five        | f1          |
-----------------------------
|             | 1234        |
-----------------------------
|             | 1235        |
-----------------------------
|             | 987         |
-----------------------------
|             | -1040       |
-----------------------------
|             | 0           |
-----------------------------
QUERY: SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 = '1234';
-----------------------------
| one         | f1          |
-----------------------------
|             | 1234        |
-----------------------------
QUERY: SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 <> '1234';
-----------------------------
| four        | f1          |
-----------------------------
|             | 1235        |
-----------------------------
|             | 987         |
-----------------------------
|             | -1040       |
-----------------------------
|             | 0           |
-----------------------------
QUERY: SELECT '' AS four, o.* FROM OID_TBL o WHERE o.f1 <= '1234';
-----------------------------
| four        | f1          |
-----------------------------
|             | 1234        |
-----------------------------
|             | 987         |
-----------------------------
|             | -1040       |
-----------------------------
|             | 0           |
-----------------------------
QUERY: SELECT '' AS three, o.* FROM OID_TBL o WHERE o.f1 < '1234';
-----------------------------
| three       | f1          |
-----------------------------
|             | 987         |
-----------------------------
|             | -1040       |
-----------------------------
|             | 0           |
-----------------------------
QUERY: SELECT '' AS two, o.* FROM OID_TBL o WHERE o.f1 >= '1234';
-----------------------------
| two         | f1          |
-----------------------------
|             | 1234        |
-----------------------------
|             | 1235        |
-----------------------------
QUERY: SELECT '' AS one, o.* FROM OID_TBL o WHERE o.f1 > '1234';
-----------------------------
| one         | f1          |
-----------------------------
|             | 1235        |
-----------------------------
QUERY: CREATE TABLE OIDCHAR16_TBL(f1 oidchar16);
QUERY: INSERT INTO OIDCHAR16_TBL(f1) VALUES ('1234,abcd');
QUERY: INSERT INTO OIDCHAR16_TBL(f1) VALUES ('1235,efgh');
QUERY: INSERT INTO OIDCHAR16_TBL(f1) VALUES ('987,XXXX');
QUERY: INSERT INTO OIDCHAR16_TBL(f1) VALUES ('123456');
WARN:Bad input data for type oidchar16
QUERY: INSERT INTO OIDCHAR16_TBL(f1) VALUES ('123456,abcdefghijklmnopqrsutvwyz');
QUERY: INSERT INTO OIDCHAR16_TBL(f1) VALUES ('');
WARN:Bad input data for type oidchar16
QUERY: INSERT INTO OIDCHAR16_TBL(f1) VALUES ('asdfasd');
WARN:Bad input data for type oidchar16
QUERY: SELECT '' AS four, OIDCHAR16_TBL.*;
-----------------------------
| four        | f1          |
-----------------------------
|             | 1234,abcd   |
-----------------------------
|             | 1235,efgh   |
-----------------------------
|             | 987,XXXX    |
-----------------------------
|             | 123456,abcdefghijklmnop|
-----------------------------
QUERY: SELECT '' AS one, o.* FROM OIDCHAR16_TBL o WHERE o.f1 = '1234,abcd';
-----------------------------
| one         | f1          |
-----------------------------
|             | 1234,abcd   |
-----------------------------
QUERY: SELECT '' AS three, o.* FROM OIDCHAR16_TBL o WHERE o.f1 <> '1234,abcd';
-----------------------------
| three       | f1          |
-----------------------------
|             | 1235,efgh   |
-----------------------------
|             | 987,XXXX    |
-----------------------------
|             | 123456,abcdefghijklmnop|
-----------------------------
QUERY: SELECT '' AS two, o.* FROM OIDCHAR16_TBL o WHERE o.f1 <= '1234,abcd';
-----------------------------
| two         | f1          |
-----------------------------
|             | 1234,abcd   |
-----------------------------
|             | 987,XXXX    |
-----------------------------
QUERY: SELECT '' AS one, o.* FROM OIDCHAR16_TBL o WHERE o.f1 < '1234,abcd';
-----------------------------
| one         | f1          |
-----------------------------
|             | 987,XXXX    |
-----------------------------
QUERY: SELECT '' AS three, o.* FROM OIDCHAR16_TBL o WHERE o.f1 >= '1234,abcd';
-----------------------------
| three       | f1          |
-----------------------------
|             | 1234,abcd   |
-----------------------------
|             | 1235,efgh   |
-----------------------------
|             | 123456,abcdefghijklmnop|
-----------------------------
QUERY: SELECT '' AS two, o.* FROM OIDCHAR16_TBL o WHERE o.f1 > '1234,abcd';
-----------------------------
| two         | f1          |
-----------------------------
|             | 1235,efgh   |
-----------------------------
|             | 123456,abcdefghijklmnop|
-----------------------------
QUERY: CREATE TABLE OIDINT2_TBL(f1 oidint2);
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('1234/9873');
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('1235/9873');
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('987/-1234');
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('123456');
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('123456/123456');
WARN:pg_atoi: error reading "123456": Math result not representable
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('');
QUERY: INSERT INTO OIDINT2_TBL(f1) VALUES ('asdfasd');
WARN:pg_atoi: error in "asdfasd": can't parse "asdfasd"
QUERY: SELECT '' AS five, OIDINT2_TBL.*;
-----------------------------
| five        | f1          |
-----------------------------
|             | 1234/9873   |
-----------------------------
|             | 1235/9873   |
-----------------------------
|             | 987/-1234   |
-----------------------------
|             | 123456/0    |
-----------------------------
|             | 0/0         |
-----------------------------
QUERY: SELECT '' AS one, o.* FROM OIDINT2_TBL o WHERE o.f1 = '1235/9873';
-----------------------------
| one         | f1          |
-----------------------------
|             | 1235/9873   |
-----------------------------
QUERY: SELECT '' AS four, o.* FROM OIDINT2_TBL o WHERE o.f1 <> '1235/9873';
-----------------------------
| four        | f1          |
-----------------------------
|             | 1234/9873   |
-----------------------------
|             | 987/-1234   |
-----------------------------
|             | 123456/0    |
-----------------------------
|             | 0/0         |
-----------------------------
QUERY: SELECT '' AS four, o.* FROM OIDINT2_TBL o WHERE o.f1 <= '1235/9873';
-----------------------------
| four        | f1          |
-----------------------------
|             | 1234/9873   |
-----------------------------
|             | 1235/9873   |
-----------------------------
|             | 987/-1234   |
-----------------------------
|             | 0/0         |
-----------------------------
QUERY: SELECT '' AS three, o.* FROM OIDINT2_TBL o WHERE o.f1 < '1235/9873';
-----------------------------
| three       | f1          |
-----------------------------
|             | 1234/9873   |
-----------------------------
|             | 987/-1234   |
-----------------------------
|             | 0/0         |
-----------------------------
QUERY: SELECT '' AS two, o.* FROM OIDINT2_TBL o WHERE o.f1 >= '1235/9873';
-----------------------------
| two         | f1          |
-----------------------------
|             | 1235/9873   |
-----------------------------
|             | 123456/0    |
-----------------------------
QUERY: SELECT '' AS one, o.* FROM OIDINT2_TBL o WHERE o.f1 > '1235/9873';
-----------------------------
| one         | f1          |
-----------------------------
|             | 123456/0    |
-----------------------------
QUERY: CREATE TABLE OIDINT4_TBL(f1 oidint4);
QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('1234/9873');
QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('1235/9873');
QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('987/-1234');
QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('123456');
QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('123456/1234568901234567890');
WARN:pg_atoi: error reading "1234568901234567890": Math result not representable
QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('');
QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('asdfasd');
WARN:pg_atoi: error in "asdfasd": can't parse "asdfasd"
QUERY: SELECT '' AS five, OIDINT4_TBL.*;
-----------------------------
| five        | f1          |
-----------------------------
|             | 1234/9873   |
-----------------------------
|             | 1235/9873   |
-----------------------------
|             | 987/-1234   |
-----------------------------
|             | 123456/0    |
-----------------------------
|             | 0/0         |
-----------------------------
QUERY: SELECT '' AS one, o.* FROM OIDINT4_TBL o WHERE o.f1 = '1235/9873';
-----------------------------
| one         | f1          |
-----------------------------
|             | 1235/9873   |
-----------------------------
QUERY: SELECT '' AS four, o.* FROM OIDINT4_TBL o WHERE o.f1 <> '1235/9873';
-----------------------------
| four        | f1          |
-----------------------------
|             | 1234/9873   |
-----------------------------
|             | 987/-1234   |
-----------------------------
|             | 123456/0    |
-----------------------------
|             | 0/0         |
-----------------------------
QUERY: SELECT '' AS four, o.* FROM OIDINT4_TBL o WHERE o.f1 <= '1235/9873';
-----------------------------
| four        | f1          |
-----------------------------
|             | 1234/9873   |
-----------------------------
|             | 1235/9873   |
-----------------------------
|             | 987/-1234   |
-----------------------------
|             | 0/0         |
-----------------------------
QUERY: SELECT '' AS three, o.* FROM OIDINT4_TBL o WHERE o.f1 < '1235/9873';
-----------------------------
| three       | f1          |
-----------------------------
|             | 1234/9873   |
-----------------------------
|             | 987/-1234   |
-----------------------------
|             | 0/0         |
-----------------------------
QUERY: SELECT '' AS two, o.* FROM OIDINT4_TBL o WHERE o.f1 >= '1235/9873';
-----------------------------
| two         | f1          |
-----------------------------
|             | 1235/9873   |
-----------------------------
|             | 123456/0    |
-----------------------------
QUERY: SELECT '' AS one, o.* FROM OIDINT4_TBL o WHERE o.f1 > '1235/9873';
-----------------------------
| one         | f1          |
-----------------------------
|             | 123456/0    |
-----------------------------
QUERY: CREATE TABLE POINT_TBL(f1 point);
QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(0.0,0.0)');
QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(-10.0,0.0)');
QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(-3.0,4.0)');
QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(5.1, 34.5)');
QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(-5.0,-12.0)');
QUERY: INSERT INTO POINT_TBL(f1) VALUES ('asdfasdf');
WARN:Bad point external representation 'asdfasdf'
QUERY: INSERT INTO POINT_TBL(f1) VALUES ('10.0,10.0');
WARN:Bad point external representation '10.0,10.0'
QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(10.0 10.0)');
WARN:Bad point external representation '(10.0 10.0)'
QUERY: INSERT INTO POINT_TBL(f1) VALUES ('(10.0,10.0');
WARN:Bad point external representation '(10.0,10.0'
QUERY: SELECT '' AS five, POINT_TBL.*;
-----------------------------
| five        | f1          |
-----------------------------
|             | (0,0)       |
-----------------------------
|             | (-10,0)     |
-----------------------------
|             | (-3,4)      |
-----------------------------
|             | (5.1,34.5)  |
-----------------------------
|             | (-5,-12)    |
-----------------------------
QUERY: SELECT '' AS three, p.* FROM POINT_TBL p WHERE p.f1 !< '(0.0, 0.0)';
-----------------------------
| three       | f1          |
-----------------------------
|             | (-10,0)     |
-----------------------------
|             | (-3,4)      |
-----------------------------
|             | (-5,-12)    |
-----------------------------
QUERY: SELECT '' AS three, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' !> p.f1;
-----------------------------
| three       | f1          |
-----------------------------
|             | (-10,0)     |
-----------------------------
|             | (-3,4)      |
-----------------------------
|             | (-5,-12)    |
-----------------------------
QUERY: SELECT '' AS one, p.* FROM POINT_TBL p WHERE '(0.0,0.0)' !^ p.f1;
-----------------------------
| one         | f1          |
-----------------------------
|             | (-5,-12)    |
-----------------------------
QUERY: SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 !| '(0.0, 0.0)';
-----------------------------
| one         | f1          |
-----------------------------
|             | (-5,-12)    |
-----------------------------
QUERY: SELECT '' AS one, p.* FROM POINT_TBL p WHERE p.f1 =|= '(5.1, 34.5)';
-----------------------------
| one         | f1          |
-----------------------------
|             | (5.1,34.5)  |
-----------------------------
QUERY: SELECT '' AS two, p.* FROM POINT_TBL p
   WHERE p.f1 ===> '(0,0,100,100)';
-----------------------------
| two         | f1          |
-----------------------------
|             | (0,0)       |
-----------------------------
|             | (5.1,34.5)  |
-----------------------------
QUERY: SELECT '' AS three, p.* FROM POINT_TBL p
   WHERE not on_pb(p.f1,'(0,0,100,100)'::box);
-----------------------------
| three       | f1          |
-----------------------------
|             | (-10,0)     |
-----------------------------
|             | (-3,4)      |
-----------------------------
|             | (-5,-12)    |
-----------------------------
QUERY: SELECT '' AS two, p.* FROM POINT_TBL p
   WHERE on_ppath(p.f1,'(0,3,0,0,-10,0,-10,10)'::path);
-----------------------------
| two         | f1          |
-----------------------------
|             | (0,0)       |
-----------------------------
|             | (-10,0)     |
-----------------------------
QUERY: SELECT '' AS five, p.f1, p.f1 <===> '(0,0)' AS dist FROM POINT_TBL p;
-------------------------------------------
| five        | f1          | dist        |
-------------------------------------------
|             | (0,0)       | 0           |
-------------------------------------------
|             | (-10,0)     | 10          |
-------------------------------------------
|             | (-3,4)      | 5           |
-------------------------------------------
|             | (5.1,34.5)  | 34          |
-------------------------------------------
|             | (-5,-12)    | 13          |
-------------------------------------------
QUERY: SELECT '' AS twentyfive, p1.f1, p2.f1, p1.f1 <===> p2.f1 AS dist
   FROM POINT_TBL p1, POINT_TBL p2;
---------------------------------------------------------
| twentyfive  | f1          | f1          | dist        |
---------------------------------------------------------
|             | (0,0)       | (0,0)       | 0           |
---------------------------------------------------------
|             | (-10,0)     | (0,0)       | 10          |
---------------------------------------------------------
|             | (-3,4)      | (0,0)       | 5           |
---------------------------------------------------------
|             | (5.1,34.5)  | (0,0)       | 34          |
---------------------------------------------------------
|             | (-5,-12)    | (0,0)       | 13          |
---------------------------------------------------------
|             | (0,0)       | (-10,0)     | 10          |
---------------------------------------------------------
|             | (-10,0)     | (-10,0)     | 0           |
---------------------------------------------------------
|             | (-3,4)      | (-10,0)     | 8           |
---------------------------------------------------------
|             | (5.1,34.5)  | (-10,0)     | 37          |
---------------------------------------------------------
|             | (-5,-12)    | (-10,0)     | 13          |
---------------------------------------------------------
|             | (0,0)       | (-3,4)      | 5           |
---------------------------------------------------------
|             | (-10,0)     | (-3,4)      | 8           |
---------------------------------------------------------
|             | (-3,4)      | (-3,4)      | 0           |
---------------------------------------------------------
|             | (5.1,34.5)  | (-3,4)      | 31          |
---------------------------------------------------------
|             | (-5,-12)    | (-3,4)      | 16          |
---------------------------------------------------------
|             | (0,0)       | (5.1,34.5)  | 34          |
---------------------------------------------------------
|             | (-10,0)     | (5.1,34.5)  | 37          |
---------------------------------------------------------
|             | (-3,4)      | (5.1,34.5)  | 31          |
---------------------------------------------------------
|             | (5.1,34.5)  | (5.1,34.5)  | 0           |
---------------------------------------------------------
|             | (-5,-12)    | (5.1,34.5)  | 47          |
---------------------------------------------------------
|             | (0,0)       | (-5,-12)    | 13          |
---------------------------------------------------------
|             | (-10,0)     | (-5,-12)    | 13          |
---------------------------------------------------------
|             | (-3,4)      | (-5,-12)    | 16          |
---------------------------------------------------------
|             | (5.1,34.5)  | (-5,-12)    | 47          |
---------------------------------------------------------
|             | (-5,-12)    | (-5,-12)    | 0           |
---------------------------------------------------------
QUERY: SELECT '' AS twenty, p1.f1, p2.f1
   FROM POINT_TBL p1, POINT_TBL p2
   WHERE (p1.f1 <===> p2.f1) > 3;
-------------------------------------------
| twenty      | f1          | f1          |
-------------------------------------------
|             | (-10,0)     | (0,0)       |
-------------------------------------------
|             | (-3,4)      | (0,0)       |
-------------------------------------------
|             | (5.1,34.5)  | (0,0)       |
-------------------------------------------
|             | (-5,-12)    | (0,0)       |
-------------------------------------------
|             | (0,0)       | (-10,0)     |
-------------------------------------------
|             | (-3,4)      | (-10,0)     |
-------------------------------------------
|             | (5.1,34.5)  | (-10,0)     |
-------------------------------------------
|             | (-5,-12)    | (-10,0)     |
-------------------------------------------
|             | (0,0)       | (-3,4)      |
-------------------------------------------
|             | (-10,0)     | (-3,4)      |
-------------------------------------------
|             | (5.1,34.5)  | (-3,4)      |
-------------------------------------------
|             | (-5,-12)    | (-3,4)      |
-------------------------------------------
|             | (0,0)       | (5.1,34.5)  |
-------------------------------------------
|             | (-10,0)     | (5.1,34.5)  |
-------------------------------------------
|             | (-3,4)      | (5.1,34.5)  |
-------------------------------------------
|             | (-5,-12)    | (5.1,34.5)  |
-------------------------------------------
|             | (0,0)       | (-5,-12)    |
-------------------------------------------
|             | (-10,0)     | (-5,-12)    |
-------------------------------------------
|             | (-3,4)      | (-5,-12)    |
-------------------------------------------
|             | (5.1,34.5)  | (-5,-12)    |
-------------------------------------------
QUERY: SELECT '' AS ten, p1.f1, p2.f1
   FROM POINT_TBL p1, POINT_TBL p2
   WHERE (p1.f1 <===> p2.f1) > 3 and
	p1.f1 !< p2.f1;
-------------------------------------------
| ten         | f1          | f1          |
-------------------------------------------
|             | (-10,0)     | (0,0)       |
-------------------------------------------
|             | (-3,4)      | (0,0)       |
-------------------------------------------
|             | (-5,-12)    | (0,0)       |
-------------------------------------------
|             | (-10,0)     | (-3,4)      |
-------------------------------------------
|             | (-5,-12)    | (-3,4)      |
-------------------------------------------
|             | (0,0)       | (5.1,34.5)  |
-------------------------------------------
|             | (-10,0)     | (5.1,34.5)  |
-------------------------------------------
|             | (-3,4)      | (5.1,34.5)  |
-------------------------------------------
|             | (-5,-12)    | (5.1,34.5)  |
-------------------------------------------
|             | (-10,0)     | (-5,-12)    |
-------------------------------------------
QUERY: SELECT '' AS two, p1.f1, p2.f1
   FROM POINT_TBL p1, POINT_TBL p2
   WHERE (p1.f1 <===> p2.f1) > 3 and
	p1.f1 !< p2.f1 and
	p1.f1 !^ p2.f1;
-------------------------------------------
| two         | f1          | f1          |
-------------------------------------------
|             | (-3,4)      | (0,0)       |
-------------------------------------------
|             | (-10,0)     | (-5,-12)    |
-------------------------------------------
QUERY: CREATE TABLE POLYGON_TBL(f1 polygon);
QUERY: INSERT INTO POLYGON_TBL(f1) VALUES ('(2.0,2.0,0.0,0.0,4.0,0.0)');
QUERY: INSERT INTO POLYGON_TBL(f1) VALUES ('(3.0,3.0,1.0,1.0,3.0,0.0)');
QUERY: INSERT INTO POLYGON_TBL(f1) VALUES ('(0.0,0.0)');
QUERY: INSERT INTO POLYGON_TBL(f1) VALUES ('(0.0,0.0,1.0,1.0)');
QUERY: INSERT INTO POLYGON_TBL(f1) VALUES ('0.0');
WARN:Bad polygon external representation '0.0'
QUERY: INSERT INTO POLYGON_TBL(f1) VALUES ('(0.0 0.0');
WARN:Bad polygon external representation '(0.0 0.0'
QUERY: INSERT INTO POLYGON_TBL(f1) VALUES ('(0,1,2)');
WARN:Bad polygon external representation '(0,1,2)'
QUERY: INSERT INTO POLYGON_TBL(f1) VALUES ('(0,1,2,3');
WARN:Bad polygon external representation '(0,1,2,3'
QUERY: INSERT INTO POLYGON_TBL(f1) VALUES ('asdf');
WARN:Bad polygon external representation 'asdf'
QUERY: SELECT '' AS four, POLYGON_TBL.*;
-----------------------------
| four        | f1          |
-----------------------------
|             | (           2,           2,           0,           0,           4,           0)|
-----------------------------
|             | (           3,           3,           1,           1,           3,           0)|
-----------------------------
|             | (           0,           0)|
-----------------------------
|             | (           0,           0,           1,           1)|
-----------------------------
QUERY: SELECT '' AS three, p.*
   FROM POLYGON_TBL p
   WHERE p.f1 && '(3.0,3.0,1.0,1.0,3.0,0.0)';
-----------------------------
| three       | f1          |
-----------------------------
|             | (           2,           2,           0,           0,           4,           0)|
-----------------------------
|             | (           3,           3,           1,           1,           3,           0)|
-----------------------------
|             | (           0,           0,           1,           1)|
-----------------------------
QUERY: SELECT '' AS four, p.*
   FROM POLYGON_TBL p
   WHERE p.f1 &< '(3.0,3.0,1.0,1.0,3.0,0.0)';
-----------------------------
| four        | f1          |
-----------------------------
|             | (           2,           2,           0,           0,           4,           0)|
-----------------------------
|             | (           3,           3,           1,           1,           3,           0)|
-----------------------------
|             | (           0,           0)|
-----------------------------
|             | (           0,           0,           1,           1)|
-----------------------------
QUERY: SELECT '' AS two, p.*
   FROM POLYGON_TBL p
   WHERE p.f1 &> '(3.0,3.0,1.0,1.0,3.0,0.0)';
-----------------------------
| two         | f1          |
-----------------------------
|             | (           2,           2,           0,           0,           4,           0)|
-----------------------------
|             | (           3,           3,           1,           1,           3,           0)|
-----------------------------
QUERY: SELECT '' AS one, p.*
   FROM POLYGON_TBL p
   WHERE p.f1 << '(3.0,3.0,1.0,1.0,3.0,0.0)';
-----------------------------
| one         | f1          |
-----------------------------
|             | (           0,           0)|
-----------------------------
QUERY: SELECT '' AS zero, p.*
   FROM POLYGON_TBL p
   WHERE p.f1 >> '(3.0,3.0,1.0,1.0,3.0,0.0)';
-----------------------------
| zero        | f1          |
-----------------------------
QUERY: SELECT '' AS one, p.*
   FROM POLYGON_TBL p
   WHERE p.f1 @ '(3.0,3.0,1.0,1.0,3.0,0.0)';
-----------------------------
| one         | f1          |
-----------------------------
|             | (           3,           3,           1,           1,           3,           0)|
-----------------------------
QUERY: SELECT '' AS one, p.*
   FROM POLYGON_TBL p
   WHERE p.f1 ~= '(3.0,3.0,1.0,1.0,3.0,0.0)';
-----------------------------
| one         | f1          |
-----------------------------
|             | (           3,           3,           1,           1,           3,           0)|
-----------------------------
QUERY: SELECT '' AS one, p.*
   FROM POLYGON_TBL p
   WHERE p.f1 ~ '(3.0,3.0,1.0,1.0,3.0,0.0)';
-----------------------------
| one         | f1          |
-----------------------------
|             | (           3,           3,           1,           1,           3,           0)|
-----------------------------
QUERY: SELECT 'char 16 string'::char16 = 'char 16 string '::char16 AS false;
---------------
| false       |
---------------
| f           |
---------------
QUERY: SELECT 'c'::char = 'c'::char AS true;
---------------
| true        |
---------------
| t           |
---------------
QUERY: SELECT 'this is a text string'::text = 'this is a text string'::text AS true;
---------------
| true        |
---------------
| t           |
---------------
QUERY: SELECT 'this is a text string'::text = 'this is a text strin'::text AS false;
---------------
| false       |
---------------
| f           |
---------------
QUERY: SELECT '(2.0,2.0,0.0,0.0,4.0,0.0)'::polygon << '(3.0,3.0,1.0,1.0,3.0,0.0)'::polygon AS false;
---------------
| false       |
---------------
| f           |
---------------
QUERY: SELECT '(2.0,2.0,0.0,0.0,4.0,0.0)'::polygon &< '(3.0,3.0,1.0,1.0,3.0,0.0)'::polygon AS true;
---------------
| true        |
---------------
| t           |
---------------
QUERY: SELECT '(2.0,2.0,0.0,0.0,4.0,0.0)'::polygon &> '(3.0,3.0,1.0,1.0,3.0,0.0)'::polygon AS true;
---------------
| true        |
---------------
| t           |
---------------
QUERY: SELECT '(2.0,2.0,0.0,0.0,4.0,0.0)'::polygon >> '(3.0,3.0,1.0,1.0,3.0,0.0)'::polygon AS false;
---------------
| false       |
---------------
| f           |
---------------
QUERY: SELECT '(2.0,2.0,0.0,0.0,4.0,0.0)'::polygon @ '(3.0,3.0,1.0,1.0,3.0,0.0)'::polygon AS false;
---------------
| false       |
---------------
| f           |
---------------
QUERY: SELECT '(2.0,2.0,0.0,0.0,4.0,0.0)'::polygon ~ '(3.0,3.0,1.0,1.0,3.0,0.0)'::polygon AS false;
---------------
| false       |
---------------
| f           |
---------------
QUERY: SELECT '(2.0,2.0,0.0,0.0,4.0,0.0)'::polygon ~= '(3.0,3.0,1.0,1.0,3.0,0.0)'::polygon AS false;
---------------
| false       |
---------------
| f           |
---------------
QUERY: SELECT '(2.0,2.0,0.0,0.0,4.0,0.0)'::polygon && '(3.0,3.0,1.0,1.0,3.0,0.0)'::polygon AS true;
---------------
| true        |
---------------
| t           |
---------------
QUERY: SELECT onek.* WHERE onek.unique1 < 10;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| unique1     | unique2     | two         | four        | ten         | twenty      | hundred     | thousand    | twothousand | fivethous   | tenthous    | odd         | even        | stringu1    | stringu2    | string4     |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 0           | 998         | 0           | 0           | 0           | 0           | 0           | 0           | 0           | 0           | 0           | 0           | 1           | AAAAAA      | KMBAAA      | OOOOxx      |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 1           | 214         | 1           | 1           | 1           | 1           | 1           | 1           | 1           | 1           | 1           | 2           | 3           | BAAAAA      | GIAAAA      | OOOOxx      |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 2           | 326         | 0           | 2           | 2           | 2           | 2           | 2           | 2           | 2           | 2           | 4           | 5           | CAAAAA      | OMAAAA      | OOOOxx      |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 3           | 431         | 1           | 3           | 3           | 3           | 3           | 3           | 3           | 3           | 3           | 6           | 7           | DAAAAA      | PQAAAA      | VVVVxx      |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 4           | 833         | 0           | 0           | 4           | 4           | 4           | 4           | 4           | 4           | 4           | 8           | 9           | EAAAAA      | BGBAAA      | HHHHxx      |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 5           | 541         | 1           | 1           | 5           | 5           | 5           | 5           | 5           | 5           | 5           | 10          | 11          | FAAAAA      | VUAAAA      | HHHHxx      |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 6           | 978         | 0           | 2           | 6           | 6           | 6           | 6           | 6           | 6           | 6           | 12          | 13          | GAAAAA      | QLBAAA      | OOOOxx      |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 7           | 647         | 1           | 3           | 7           | 7           | 7           | 7           | 7           | 7           | 7           | 14          | 15          | HAAAAA      | XYAAAA      | VVVVxx      |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 8           | 653         | 0           | 0           | 8           | 8           | 8           | 8           | 8           | 8           | 8           | 16          | 17          | IAAAAA      | DZAAAA      | HHHHxx      |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 9           | 49          | 1           | 1           | 9           | 9           | 9           | 9           | 9           | 9           | 9           | 18          | 19          | JAAAAA      | XBAAAA      | HHHHxx      |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
QUERY: SELECT onek.unique1, onek.stringu1
   WHERE onek.unique1 < 20
   ORDER BY unique1 using >;
-----------------------------
| unique1     | stringu1    |
-----------------------------
| 19          | TAAAAA      |
-----------------------------
| 18          | SAAAAA      |
-----------------------------
| 17          | RAAAAA      |
-----------------------------
| 16          | QAAAAA      |
-----------------------------
| 15          | PAAAAA      |
-----------------------------
| 14          | OAAAAA      |
-----------------------------
| 13          | NAAAAA      |
-----------------------------
| 12          | MAAAAA      |
-----------------------------
| 11          | LAAAAA      |
-----------------------------
| 10          | KAAAAA      |
-----------------------------
| 9           | JAAAAA      |
-----------------------------
| 8           | IAAAAA      |
-----------------------------
| 7           | HAAAAA      |
-----------------------------
| 6           | GAAAAA      |
-----------------------------
| 5           | FAAAAA      |
-----------------------------
| 4           | EAAAAA      |
-----------------------------
| 3           | DAAAAA      |
-----------------------------
| 2           | CAAAAA      |
-----------------------------
| 1           | BAAAAA      |
-----------------------------
| 0           | AAAAAA      |
-----------------------------
QUERY: SELECT onek.unique1, onek.stringu1
   WHERE onek.unique1 > 980
   ORDER BY stringu1 using <;
WARN:cannot write block 0 of temp_252078
QUERY: SELECT onek.unique1, onek.string4
   WHERE onek.unique1 > 980
   ORDER BY string4 using <, unique1 using >;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT onek.unique1, onek.string4
   WHERE onek.unique1 > 980
   ORDER BY string4 using >, unique1 using <;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT onek.unique1, onek.string4
   WHERE onek.unique1 < 20
   ORDER BY unique1 using >, string4 using <;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT onek.unique1, onek.string4
   WHERE onek.unique1 < 20
   ORDER BY unique1 using <, string4 using >;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT onek2.* WHERE onek2.unique1 < 10;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT onek2.unique1, onek2.stringu1
    WHERE onek2.unique1 < 20
    ORDER BY unique1 using >;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT onek2.unique1, onek2.stringu1
   WHERE onek2.unique1 > 980
   ORDER BY stringu1 using <;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT two, stringu1, ten, string4
   INTO TABLE temp
   FROM onek;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT DISTINCT two FROM temp;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT DISTINCT ten FROM temp;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT DISTINCT string4 FROM temp;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT DISTINCT two, string4, ten
   FROM temp
   ORDER BY two using <, string4 using <, ten using <;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT DISTINCT ON string4 two, string4, ten
	   FROM temp
   ORDER BY two using <, string4 using <, ten using <;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT *
   INTO TABLE temp1
   FROM temp
   WHERE onek.unique1 < 2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DROP TABLE temp1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT *
   INTO TABLE temp1
   FROM temp
   WHERE onek2.unique1 < 2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DROP TABLE temp1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT p.name, p.age FROM person* p;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT p.name, p.age FROM person* p ORDER BY age using >;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT DISTINCT p.age FROM person* p ORDER BY age using >;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT hash_i4_heap.*
   WHERE hash_i4_heap.random = 843938989;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT hash_i4_heap.*
   WHERE hash_i4_heap.random = 66766766;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT hash_c16_heap.*
   WHERE hash_c16_heap.random = '1505703298'::char16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT hash_c16_heap.*
   WHERE hash_c16_heap.random = '7777777'::char16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT hash_txt_heap.*
   WHERE hash_txt_heap.random = '1351610853'::text;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT hash_txt_heap.*
   WHERE hash_txt_heap.random = '111111112222222233333333'::text;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT hash_f8_heap.*
   WHERE hash_f8_heap.random = '444705537'::float8;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT hash_f8_heap.*
   WHERE hash_f8_heap.random = '88888888'::float8;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT b.*
   FROM bt_i4_heap b
   WHERE b.seqno < 1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT b.*
   FROM bt_i4_heap b
   WHERE b.seqno >= 9999;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT b.*
   FROM bt_i4_heap b
   WHERE b.seqno = 4500;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT b.*
   FROM bt_c16_heap b
   WHERE b.seqno < '1'::char16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT b.*
   FROM bt_c16_heap b
   WHERE b.seqno >= '9999'::char16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT b.*
   FROM bt_c16_heap b
   WHERE b.seqno = '4500'::char16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT b.*
   FROM bt_txt_heap b
   WHERE b.seqno < '1'::text;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT b.*
   FROM bt_txt_heap b
   WHERE b.seqno >= '9999'::text;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT b.*
   FROM bt_txt_heap b
   WHERE b.seqno = '4500'::text;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT b.*
   FROM bt_f8_heap b
   WHERE b.seqno < '1'::float8;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT b.*
   FROM bt_f8_heap b
   WHERE b.seqno >= '9999'::float8;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT b.*
   FROM bt_f8_heap b
   WHERE b.seqno = '4500'::float8;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE onek
   SET unique1 = onek.unique1 + 1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE onek
   SET unique1 = onek.unique1 - 1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE onek2
   SET unique1 = onek2.unique1 + 1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE onek2
   SET unique1 = onek2.unique1 - 1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE temp
   SET stringu1 = reverse_c16(onek.stringu1)
   WHERE onek.stringu1 = 'JBAAAA' and
	  onek.stringu1 = temp.stringu1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE temp
   SET stringu1 = reverse_c16(onek2.stringu1)
   WHERE onek2.stringu1 = 'JCAAAA' and
	  onek2.stringu1 = temp.stringu1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DROP TABLE temp;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE hash_i4_heap
   SET random = 1
   WHERE hash_i4_heap.seqno = 1492;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT h.seqno AS i1492, h.random AS i1
   FROM hash_i4_heap h
   WHERE h.random = 1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE hash_i4_heap
   SET seqno = 20000
   WHERE hash_i4_heap.random = 1492795354;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT h.seqno AS i20000
   FROM hash_i4_heap h
   WHERE h.random = 1492795354;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE hash_c16_heap
   SET random = '0123456789abcdef'::char16
   WHERE hash_c16_heap.seqno = 6543;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT h.seqno AS i6543, h.random AS c0_to_f
   FROM hash_c16_heap h
   WHERE h.random = '0123456789abcdef'::char16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE hash_c16_heap
   SET seqno = 20000
   WHERE hash_c16_heap.random = '76652222'::char16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT h.seqno AS emptyset
   FROM hash_c16_heap h
   WHERE h.random = '76652222'::char16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE hash_txt_heap
   SET random = '0123456789abcdefghijklmnop'::text
   WHERE hash_txt_heap.seqno = 4002;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT h.seqno AS i4002, h.random AS c0_to_p
   FROM hash_txt_heap h
   WHERE h.random = '0123456789abcdefghijklmnop'::text;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE hash_txt_heap
   SET seqno = 20000
   WHERE hash_txt_heap.random = '959363399'::text;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT h.seqno AS t20000
   FROM hash_txt_heap h
   WHERE h.random = '959363399'::text;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE hash_f8_heap
   SET random = '-1234.1234'::float8
   WHERE hash_f8_heap.seqno = 8906;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT h.seqno AS i8096, h.random AS f1234_1234
   FROM hash_f8_heap h
   WHERE h.random = '-1234.1234'::float8;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: UPDATE hash_f8_heap
   SET seqno = 20000
   WHERE hash_f8_heap.random = '488912369'::float8;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT h.seqno AS f20000
   FROM hash_f8_heap h
   WHERE h.random = '488912369'::float8;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: COPY onek TO '/usr/local/postgres95/src/test/regress/obj/onek.data';
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DELETE FROM onek;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: COPY onek FROM '/usr/local/postgres95/src/test/regress/obj/onek.data';
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT unique1 FROM onek WHERE unique1 < 2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DELETE FROM onek2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: COPY onek2 FROM '/usr/local/postgres95/src/test/regress/obj/onek.data';
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT unique1 FROM onek2 WHERE unique1 < 2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: COPY BINARY stud_emp TO '/usr/local/postgres95/src/test/regress/obj/stud_emp.data';
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DELETE FROM stud_emp;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: COPY BINARY stud_emp FROM '/usr/local/postgres95/src/test/regress/obj/stud_emp.data';
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT * FROM stud_emp;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT count(*) FROM onek;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: BEGIN;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT *
   INTO TABLE xacttest
   FROM aggtest;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: INSERT INTO xacttest (a, b) VALUES (777, 777.777);
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: END;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT a FROM xacttest WHERE a > 100;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: BEGIN;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CREATE TABLE disappear (a int4);
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DELETE FROM aggtest;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT * FROM aggtest;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ABORT;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT oid FROM pg_class WHERE relname = 'disappear';
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT * FROM aggtest;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: BEGIN;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo1 CURSOR FOR SELECT * FROM tenk1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo2 CURSOR FOR SELECT * FROM tenk2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo3 CURSOR FOR SELECT * FROM tenk1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo4 CURSOR FOR SELECT * FROM tenk2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo5 CURSOR FOR SELECT * FROM tenk1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo6 CURSOR FOR SELECT * FROM tenk2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo7 CURSOR FOR SELECT * FROM tenk1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo8 CURSOR FOR SELECT * FROM tenk2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo9 CURSOR FOR SELECT * FROM tenk1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo10 CURSOR FOR SELECT * FROM tenk2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo11 CURSOR FOR SELECT * FROM tenk1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo12 CURSOR FOR SELECT * FROM tenk2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo13 CURSOR FOR SELECT * FROM tenk1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo14 CURSOR FOR SELECT * FROM tenk2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo15 CURSOR FOR SELECT * FROM tenk1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo16 CURSOR FOR SELECT * FROM tenk2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo17 CURSOR FOR SELECT * FROM tenk1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo18 CURSOR FOR SELECT * FROM tenk2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo19 CURSOR FOR SELECT * FROM tenk1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo20 CURSOR FOR SELECT * FROM tenk2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo21 CURSOR FOR SELECT * FROM tenk1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo22 CURSOR FOR SELECT * FROM tenk2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo23 CURSOR FOR SELECT * FROM tenk1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 1 in foo1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 2 in foo2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 3 in foo3;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 4 in foo4;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 5 in foo5;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 6 in foo6;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 7 in foo7;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 8 in foo8;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 9 in foo9;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 10 in foo10;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 11 in foo11;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 12 in foo12;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 13 in foo13;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 14 in foo14;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 15 in foo15;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 16 in foo16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 17 in foo17;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 18 in foo18;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 19 in foo19;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 20 in foo20;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 21 in foo21;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 22 in foo22;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH 23 in foo23;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 1 in foo23;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 2 in foo22;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 3 in foo21;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 4 in foo20;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 5 in foo19;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 6 in foo18;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 7 in foo17;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 8 in foo16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 9 in foo15;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 10 in foo14;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 11 in foo13;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 12 in foo12;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 13 in foo11;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 14 in foo10;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 15 in foo9;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 16 in foo8;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 17 in foo7;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 18 in foo6;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 19 in foo5;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 20 in foo4;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 21 in foo3;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 22 in foo2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH backward 23 in foo1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo1;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo3;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo4;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo5;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo6;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo7;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo8;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo9;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo10;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo11;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo12;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: end;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: EXTEND INDEX onek2_u1_prtl WHERE onek2.unique1 <= 60;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: BEGIN;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo13 CURSOR FOR
   SELECT * FROM onek WHERE unique1 = 50;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo14 CURSOR FOR
   SELECT * FROM onek WHERE unique1 = 51;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo15 CURSOR FOR
   SELECT * FROM onek WHERE unique1 = 52;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo16 CURSOR FOR
   SELECT * FROM onek WHERE unique1 = 53;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo17 CURSOR FOR
   SELECT * FROM onek WHERE unique1 = 54;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo18 CURSOR FOR
   SELECT * FROM onek WHERE unique1 = 55;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo19 CURSOR FOR
   SELECT * FROM onek WHERE unique1 = 56;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo20 CURSOR FOR
   SELECT * FROM onek WHERE unique1 = 57;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo21 CURSOR FOR
   SELECT * FROM onek WHERE unique1 = 58;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo22 CURSOR FOR
   SELECT * FROM onek WHERE unique1 = 59;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo23 CURSOR FOR
   SELECT * FROM onek WHERE unique1 = 60;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo24 CURSOR FOR
   SELECT * FROM onek2 WHERE unique1 = 50;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DECLARE foo25 CURSOR FOR
   SELECT * FROM onek2 WHERE unique1 = 60;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH all in foo13;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH all in foo14;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH all in foo15;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH all in foo16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH all in foo17;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH all in foo18;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH all in foo19;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH all in foo20;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH all in foo21;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH all in foo22;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH all in foo23;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH all in foo24;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: FETCH all in foo25;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo13;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo14;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo15;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo17;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo18;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo19;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo20;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo21;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo22;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo23;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo24;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CLOSE foo25;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: END;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: PURGE hash_f8_heap BEFORE 'now';		-- absolute time
SELECT count(*) AS has_10002 FROM hash_f8_heap[,] h;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: VACUUM hash_f8_heap;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT count(*) AS has_10000 FROM hash_f8_heap[,] h;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: PURGE hash_i4_heap AFTER '@ 1 second ago';	-- relative time
SELECT count(*) AS has_10002 FROM hash_i4_heap[,] h;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: VACUUM hash_i4_heap;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT count(*) AS has_10000 FROM hash_i4_heap[,] h;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CREATE TABLE temp (initial int4);
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN a int4;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN b char16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN c text;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN d float8;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN e float4;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN f int2;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN g polygon;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN h abstime;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN i char;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN j abstime[];
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN k dt;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN l tid;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN m xid;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN n oid8;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN p smgr;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN q point;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN r lseg;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN s path;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN t box;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN u tinterval;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN v oidint4;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN w oidchar16;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN x float8[];
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN y float4[];
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN z int2[];
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: INSERT INTO temp (a, b, c, d, e, f, g, h, i, j, k, l, m, n, p, q, r, s, t, u,
	v, w, x, y, z)
   VALUES (4, 'char16', 'text', 4.1, 4.1, 2, '(4.1,4.1,3.1,3.1)',
        'Mon May  1 00:30:30 PDT 1995', 'c', '{Mon May  1 00:30:30 PDT 1995, Monday Aug 24 14:43:07 1992 PDT, epoch}',
	314159, '(1,1)', 512,
	'1 2 3 4 5 6 7 8', 'magnetic disk', '(1.1,1.1)', '(4.1,4.1,3.1,3.1)',
	'(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["current" "infinity"]',
	'1/3', '1,char16', '{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: SELECT * FROM temp;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: DROP TABLE temp;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: CREATE TABLE temp (
	initial 	int4
) ARCHIVE = light;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN a int4;
NOTICE:AbortTransaction and not in in-progress state 
WARN:cannot unlink temp_252079
QUERY: ALTER TABLE temp ADD COLUMN b char16;

===============================================================================
  To unsubscribe from the Postgres95 mailing list, send mail with the subject
  line "DEL" to "postgres95-request@postgres.Berkeley.EDU". 
============  URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres95/  ===========
