crash_20120918.txt
text/plain
--------------------------------------------------------------- [int4 START ] --
-- datatype [int4]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning int4 with wrapper
);
ERROR: cannot cast jsonb array to type integer
--------------------------------------------------------------- [int4 END ] --
--------------------------------------------------------------- [bit START ] --
-- datatype [bit]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning bit with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [bit END ] --
--------------------------------------------------------------- [bigint START ] --
-- datatype [bigint]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning bigint with wrapper
);
ERROR: cannot cast jsonb array to type bigint
--------------------------------------------------------------- [bigint END ] --
--------------------------------------------------------------- [bit varying START ] --
-- datatype [bit varying]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning bit varying with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [bit varying END ] --
--------------------------------------------------------------- [boolean START ] --
-- datatype [boolean]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning boolean with wrapper
);
ERROR: cannot cast jsonb array to type boolean
--------------------------------------------------------------- [boolean END ] --
--------------------------------------------------------------- [box START ] --
-- datatype [box]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning box with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [box END ] --
--------------------------------------------------------------- [bytea START ] --
-- datatype [bytea]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning bytea with wrapper
);
json_query
----------------
\x5b322c20335d
(1 row)
--------------------------------------------------------------- [bytea END ] --
--------------------------------------------------------------- [character varying(5) START ] --
-- datatype [character varying(5)]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning character varying(5) with wrapper
);
json_query
------------
[2, 3
(1 row)
--------------------------------------------------------------- [character varying(5) END ] --
--------------------------------------------------------------- [cidr START ] --
-- datatype [cidr]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning cidr with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [cidr END ] --
--------------------------------------------------------------- [circle START ] --
-- datatype [circle]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning circle with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [circle END ] --
--------------------------------------------------------------- [date START ] --
-- datatype [date]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning date with wrapper
);
json_query
------------
2000-01-01
(1 row)
--------------------------------------------------------------- [date END ] --
--------------------------------------------------------------- [double precision START ] --
-- datatype [double precision]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning double precision with wrapper
);
ERROR: cannot cast jsonb array to type double precision
--------------------------------------------------------------- [double precision END ] --
--------------------------------------------------------------- [float START ] --
-- datatype [float]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning float with wrapper
);
ERROR: cannot cast jsonb array to type double precision
--------------------------------------------------------------- [float END ] --
--------------------------------------------------------------- [inet START ] --
-- datatype [inet]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning inet with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [inet END ] --
--------------------------------------------------------------- [interval START ] --
-- datatype [interval]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning interval with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [interval END ] --
--------------------------------------------------------------- [json START ] --
-- datatype [json]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning json with wrapper
);
json_query
------------
[2, 3]
(1 row)
--------------------------------------------------------------- [json END ] --
--------------------------------------------------------------- [jsonb START ] --
-- datatype [jsonb]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning jsonb with wrapper
);
json_query
------------
[2, 3]
(1 row)
--------------------------------------------------------------- [jsonb END ] --
--------------------------------------------------------------- [line START ] --
-- datatype [line]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning line with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [line END ] --
--------------------------------------------------------------- [lseg START ] --
-- datatype [lseg]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning lseg with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [lseg END ] --
--------------------------------------------------------------- [macaddr START ] --
-- datatype [macaddr]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning macaddr with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [macaddr END ] --
--------------------------------------------------------------- [macaddr8 START ] --
-- datatype [macaddr8]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning macaddr8 with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [macaddr8 END ] --
--------------------------------------------------------------- [money START ] --
-- datatype [money]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning money with wrapper
);
json_query
------------
$0.00
(1 row)
--------------------------------------------------------------- [money END ] --
--------------------------------------------------------------- [numeric START ] --
-- datatype [numeric]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning numeric with wrapper
);
ERROR: cannot cast jsonb array to type numeric
--------------------------------------------------------------- [numeric END ] --
--------------------------------------------------------------- [path START ] --
-- datatype [path]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning path with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [path END ] --
--------------------------------------------------------------- [pg_lsn START ] --
-- datatype [pg_lsn]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning pg_lsn with wrapper
);
json_query
------------
0/0
(1 row)
--------------------------------------------------------------- [pg_lsn END ] --
--------------------------------------------------------------- [point START ] --
-- datatype [point]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning point with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [point END ] --
--------------------------------------------------------------- [polygon START ] --
-- datatype [polygon]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning polygon with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [polygon END ] --
--------------------------------------------------------------- [real START ] --
-- datatype [real]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning real with wrapper
);
ERROR: cannot cast jsonb array to type real
--------------------------------------------------------------- [real END ] --
--------------------------------------------------------------- [smallint START ] --
-- datatype [smallint]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning smallint with wrapper
);
ERROR: cannot cast jsonb array to type smallint
--------------------------------------------------------------- [smallint END ] --
--------------------------------------------------------------- [serial START ] --
-- datatype [serial]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning serial with wrapper
);
ERROR: type "serial" does not exist
LINE 2: '$.a[*].a?(@<=3)'returning serial with wrapper
^
--------------------------------------------------------------- [serial END ] --
--------------------------------------------------------------- [text START ] --
-- datatype [text]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning text with wrapper
);
json_query
------------
[2, 3]
(1 row)
--------------------------------------------------------------- [text END ] --
--------------------------------------------------------------- [time START ] --
-- datatype [time]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning time with wrapper
);
json_query
------------
00:00:00
(1 row)
--------------------------------------------------------------- [time END ] --
--------------------------------------------------------------- [time without time zone START ] --
-- datatype [time without time zone]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning time without time zone with wrapper
);
json_query
------------
00:00:00
(1 row)
--------------------------------------------------------------- [time without time zone END ] --
--------------------------------------------------------------- [time with time zone START ] --
-- datatype [time with time zone]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning time with time zone with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [time with time zone END ] --
--------------------------------------------------------------- [timestamp START ] --
-- datatype [timestamp]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning timestamp with wrapper
);
json_query
---------------------
2000-01-01 00:00:00
(1 row)
--------------------------------------------------------------- [timestamp END ] --
--------------------------------------------------------------- [timestamp without time zone START ] --
-- datatype [timestamp without time zone]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning timestamp without time zone with wrapper
);
json_query
---------------------
2000-01-01 00:00:00
(1 row)
--------------------------------------------------------------- [timestamp without time zone END ] --
--------------------------------------------------------------- [timestamp with time zone START ] --
-- datatype [timestamp with time zone]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning timestamp with time zone with wrapper
);
json_query
------------------------
2000-01-01 01:00:00+01
(1 row)
--------------------------------------------------------------- [timestamp with time zone END ] --
--------------------------------------------------------------- [tsquery START ] --
-- datatype [tsquery]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning tsquery with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [tsquery END ] --
--------------------------------------------------------------- [tsvector START ] --
-- datatype [tsvector]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning tsvector with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [tsvector END ] --
--------------------------------------------------------------- [uuid START ] --
-- datatype [uuid]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning uuid with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [uuid END ] --
--------------------------------------------------------------- [txid_snapshot START ] --
-- datatype [txid_snapshot]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning txid_snapshot with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [txid_snapshot END ] --
--------------------------------------------------------------- [xml START ] --
-- datatype [xml]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning xml with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [xml END ] --
--------------------------------------------------------------- [decimal START ] --
-- datatype [decimal]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning decimal with wrapper
);
ERROR: cannot cast jsonb array to type numeric
--------------------------------------------------------------- [decimal END ] --
--------------------------------------------------------------- [char(4) START ] --
-- datatype [char(4)]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning char(4) with wrapper
);
json_query
------------
[2,
(1 row)
--------------------------------------------------------------- [char(4) END ] --
--------------------------------------------------------------- [character(4) START ] --
-- datatype [character(4)]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning character(4) with wrapper
);
json_query
------------
[2,
(1 row)
--------------------------------------------------------------- [character(4) END ] --
--------------------------------------------------------------- [bit(3) START ] --
-- datatype [bit(3)]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning bit(3) with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [bit(3) END ] --
--------------------------------------------------------------- [int4range START ] --
-- datatype [int4range]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning int4range with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [int4range END ] --
--------------------------------------------------------------- [int4multirange START ] --
-- datatype [int4multirange]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning int4multirange with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [int4multirange END ] --
--------------------------------------------------------------- [int8range START ] --
-- datatype [int8range]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning int8range with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [int8range END ] --
--------------------------------------------------------------- [int8multirange START ] --
-- datatype [int8multirange]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning int8multirange with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [int8multirange END ] --
--------------------------------------------------------------- [numrange START ] --
-- datatype [numrange]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning numrange with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [numrange END ] --
--------------------------------------------------------------- [nummultirange START ] --
-- datatype [nummultirange]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning nummultirange with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [nummultirange END ] --
--------------------------------------------------------------- [tsrange START ] --
-- datatype [tsrange]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning tsrange with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [tsrange END ] --
--------------------------------------------------------------- [tsmultirange START ] --
-- datatype [tsmultirange]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning tsmultirange with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [tsmultirange END ] --
--------------------------------------------------------------- [tstzrange START ] --
-- datatype [tstzrange]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning tstzrange with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [tstzrange END ] --
--------------------------------------------------------------- [tstzmultirange START ] --
-- datatype [tstzmultirange]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning tstzmultirange with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [tstzmultirange END ] --
--------------------------------------------------------------- [daterange START ] --
-- datatype [daterange]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning daterange with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [daterange END ] --
--------------------------------------------------------------- [datemultirange START ] --
-- datatype [datemultirange]
select json_query(jsonb'{"a":[{"a":[2,3]},{"a":[4,5]}]}',
'$.a[*].a?(@<=3)'returning datemultirange with wrapper
);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
--------------------------------------------------------------- [datemultirange END ] --