On Sat, 2012-03-10 at 09:59 -0500, Colin Beckingham wrote:
>
> On 03/10/2012 09:19 AM, Colin Beckingham wrote:
> >
> >
> > On 03/10/2012 08:38 AM, Guillaume Lelarge wrote:
> >> On Fri, 2012-03-09 at 05:09 -0500, Colin Beckingham wrote:
> >>> [...]
> >>> select distinct on (mname, nname) mname, nna
On 03/10/2012 09:19 AM, Colin Beckingham wrote:
On 03/10/2012 08:38 AM, Guillaume Lelarge wrote:
On Fri, 2012-03-09 at 05:09 -0500, Colin Beckingham wrote:
[...]
select distinct on (mname, nname) mname, nname from grammar \
inner join majors using (mid) \
inner join minors using (nid) \
inn
On 03/10/2012 08:38 AM, Guillaume Lelarge wrote:
On Fri, 2012-03-09 at 05:09 -0500, Colin Beckingham wrote:
[...]
select distinct on (mname, nname) mname, nname from grammar \
inner join majors using (mid) \
inner join minors using (nid) \
inner join j
On Fri, 2012-03-09 at 05:09 -0500, Colin Beckingham wrote:
> [...]
> select distinct on (mname, nname) mname, nname from grammar \
> inner join majors using (mid) \
> inner join minors using (nid) \
> inner join jxgp using (gid) \
> where jxgp.pid = 9
Using latest 1.15 dev, opensuse 12.1 64 bit.
This is a tough one to describe, no backtrace to offer, no segfault or
other command line message.
1. Open pgadmin, select correct db, open query builder, all ok.
2. cut and paste from Kwrite editor Python code as follows:
select distinct on (mname
