Re: [Postgres-xc-developers] GROUP BY clause with JOIN clause and DISTINCT clause and combination of implicit/explicit table specification

[鈴木 幸市 <ko...@in...>]

Yes, you can do it with SET command as well just for a target statement.

Regards;
---
Koichi Suzuki

2013/11/21 7:46、Michael Paquier <mic...@gm...> のメール：

> On Thu, Nov 21, 2013 at 12:32 AM, Masataka Saito <pg...@gm...> wrote:
>> XC can't build a plan.
>> 
>> db=# explain verbose SELECT DISTINCT t2.b FROM t1 JOIN t2 ON t1.id =
>> t2.id GROUP BY b;
>> ERROR:  ORDER/GROUP BY expression not found in targetlist
> This is a higher-level bug, planner bug just by looking at this code
> path src/backend/optimizer/util/tlist.c...
> 
> Note: Setting up VERBOSITY to verbose in .psqlrc helps grabbing more
> details about the errors that occurred in server like the file name +
> name of this elog/ereport ERROR:
> \set VERBOSITY verbose
> For dev purposes it is a pretty useful default ;)
> 
> Regards,
> -- 
> Michael
> 
> ------------------------------------------------------------------------------
> Shape the Mobile Experience: Free Subscription
> Software experts and developers: Be at the forefront of tech innovation.
> Intel(R) Software Adrenaline delivers strategic insight and game-changing 
> conversations that shape the rapidly evolving mobile landscape. Sign up now. 
> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>