The actual query was something like:
select id, person, unnest(groups) as grp from people
… where groups is a crazy column containing an array that needed to be joined
with another table. In this case, you cannot do your suggested solution, which
would look like this:
select id, person, grp fr
ff Davis
>To: o...@sai.msu.su
>Cc: Denis de Bernardy ; Teodor Sigaev
>; pgsql-bugs@postgresql.org
>Sent: Sunday, June 19, 2011 7:23 PM
>Subject: Re: PG regression with row comparison when btree_gist is enabled (BUG)
>
>On Sat, 2011-06-18 at 13:20 -0700, Jeff Davis wrote:
&g
Wrapping apparently doesn't want to work in expanded mode...
Lengthier discussion here:
http://stackoverflow.com/questions/6306063/
test=# \t
Showing only tuples.
test=# \pset border 0
Border style is 0.
test=# \pset format wrapped
Output format is wrapped.
test=# \pset columns 20
Target width
Pardon if I insist, but accepting data that contradicts an external key
contraint without raising an error is a bug and by no means a feature.
Denis
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 10, 2006 11:35 PM
> To: Denis de B
Step by step how to reproduce:
-- nodes
CREATE TABLE nodes
(
node_id serial,
CONSTRAINT nodes_pkey PRIMARY KEY (node_id)
)
WITHOUT OIDS;
-- domains
CREATE TABLE domains
(
domain_id int NOT NULL,
domain_is_p
