Skip site navigation (1) Skip section navigation (2)

Re: faster output from php and postgres

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Chadwick Rolfs <cmr(at)shell(dot)gis(dot)net>
Cc: Lonnie VanZandt <lonniev(at)predictableresponse(dot)com>,"'scott(dot)marlowe'" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-php(at)postgresql(dot)org,pgsql-sql(at)postgresql(dot)org
Subject: Re: faster output from php and postgres
Date: 2003-05-24 22:00:09
Message-ID: 20030524220009.GA6260@wolff.to (view raw or flat)
Thread:
Lists: pgsql-phppgsql-sql
On Sat, May 24, 2003 at 13:02:29 -0400,
  Chadwick Rolfs <cmr(at)shell(dot)gis(dot)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;

In response to

pgsql-php by date

Next:From: Frank BaxDate: 2003-05-25 02:01:30
Subject: Re: faster output from php and postgres
Previous:From: Chadwick RolfsDate: 2003-05-24 17:02:29
Subject: Re: faster output from php and postgres

pgsql-sql by date

Next:From: Frank BaxDate: 2003-05-25 02:01:30
Subject: Re: faster output from php and postgres
Previous:From: Jan WieckDate: 2003-05-24 21:11:51
Subject: Re: see toast table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group