Re: Error in Query Builder: multi-line sql

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Colin Beckingham <colbec(at)start(dot)ca>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Error in Query Builder: multi-line sql
Date: 2012-03-10 13:38:09
Message-ID: 1331386689.2339.5.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-03-10 13:47:52 Re: BUG
Previous Message Guillaume Lelarge 2012-03-10 11:52:22 Re: Error on delete row