[GENERAL] [GRNERAL] drop domain xx cascade

2010-01-26 Thread hx.li
public.TT" Column | Type | Modifiers +--+--- tt_c | numeric(5,2) | Any help is appreciated! Hx.li -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] FULL JOIN is only supported with merge-joinable join conditions

2010-01-06 Thread hx.li
> It's an implementation restriction. If the clauses aren't mergejoinable > there's no very practical way to keep track of which inner-side rows > have had a match. If we could consider it is equivalent transformation as follow? select * from t_1 full outer join t_3 on t_1.a=1; and select * fr

[GENERAL] FULL JOIN is only supported with merge-joinable join conditions

2010-01-06 Thread hx.li
Hi guys, I have a question about outer join. For example as follow (pg 8.4.1): -- create table t_1(a int); create table t_3(a int); insert into t_1 values(1); insert into t_1 values(2); insert into t_3 values(1); insert into t_3 values(3); postgres=# select version();