Re: [SQL] [PHP] faster output from php and postgres (one resolution)

2003-05-30 Thread Chadwick Rolfs
y not use PHP to concatenate the authors while pub_id is the same??? > If you insist on having each author in its own column, > put them at the end and concatenate with . > > jll > > > Chadwick Rolfs wrote: > > > > So, I have the same problem, but I need all auth

Re: [SQL] [PHP] faster output from php and postgres

2003-05-27 Thread Chadwick Rolfs
having each author in its own column, > put them at the end and concatenate with . > > jll > > > Chadwick Rolfs wrote: > > > > So, I have the same problem, but I need all authors for each publication > > to show up in it's own column. I tried the full j

Re: [SQL] [PHP] faster output from php and postgres

2003-05-27 Thread Chadwick Rolfs
On Tue, 27 May 2003, Richard Huxton wrote: > On Tuesday 27 May 2003 5:34 pm, Chadwick Rolfs wrote: > > So, I have the same problem, but I need all authors for each publication > > to show up in it's own column. I tried the full join query from a > > suggestion off pgsq

Re: [SQL] [PHP] faster output from php and postgres

2003-05-27 Thread Chadwick Rolfs
g the > question. I've even seen examples where the process goes through several > emails before SQL produces desired results exactly. > > >How would a join make this easier? > > I have always found that one properly constructed complex query is always > &q