Re: [pgadmin-support] Error in Query Builder: multi-line sql

2012-03-10 Thread Guillaume Lelarge
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

Re: [pgadmin-support] Error in Query Builder: multi-line sql

2012-03-10 Thread Colin Beckingham
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

Re: [pgadmin-support] Error in Query Builder: multi-line sql

2012-03-10 Thread Colin Beckingham
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

Re: [pgadmin-support] Error in Query Builder: multi-line sql

2012-03-10 Thread Guillaume Lelarge
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