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 >
It seems hard to reproduce. Can you send me the tables's definition? (grammar, majors, minors, jxpg) It'll be easier and quicker for me than trying to figure out their definitions. Thanks. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
