pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bruno Wolff III <bruno@wolff.to>
To: Chadwick Rolfs <cmr@shell.gis.net>
Cc: Lonnie VanZandt <lonniev@predictableresponse.com>
Cc: 'scott.marlowe' <scott.marlowe@ihs.com>
Cc: pgsql-php@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: faster output from php and postgres
Date: Sat, 24 May 2003 17:00:09 -0500
Message-ID: <20030524220009.GA6260@wolff.to> (raw)
In-Reply-To: <Pine.GSO.4.05.10305241259160.27954-100000@shell.gis.net>
References: <009601c32150$66a78220$113ea8c0@predictable>
	<Pine.GSO.4.05.10305241259160.27954-100000@shell.gis.net>

On Sat, May 24, 2003 at 13:02:29 -0400,
  Chadwick Rolfs <cmr@shell.gis.net> wrote:
> As a person with the same problem, I would love to know how to do this.
> The concept escapes me, but maybe these lists could help with novice
> sqlers.
> 
> If there are multiple authors per publication (my case), and each author
> needs to be selected and displayed, how can that be done via a join?
> 
> One would need to query for all authors with each publication.

You would do something like:
select pub.pubname, auth.authname
  from pub, auth, pub_auth
  where
    pub.pubid = pub_auth.pubid and
    auth.authid = pub_auth.authid
  order by pub.pubname, auth.authname;



view thread (15+ messages)  latest in thread

Message-ID: <20030524220009.GA6260@wolff.to>
Permalink:  ../20030524220009.GA6260@wolff.to/
Also on:    postgresql.org/message-id/20030524220009.GA6260@wolff.to

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: bruno@wolff.to, cmr@shell.gis.net, lonniev@predictableresponse.com, scott.marlowe@ihs.com, pgsql-php@postgresql.org
  Subject: Re: faster output from php and postgres
  In-Reply-To: <20030524220009.GA6260@wolff.to>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox