I've got a strange bug in the way php and postgresql are interacting.
(versions: pgsql 7.1.3, apache 1.3.14 through 20, php 4.0.6)
When I use this query in a psql monitor, it works fine, and returns the columns from both phonebook and emt.
select * from phonebook left join emt using (enum) where cbcpr='T' or cbemt='T';
phonebook is a huge ugly catchall table, while emt has the hours, and emergency contact number of Emergency medical techs and CPR folks in our company.
Since we want to list all emt/cpr folks whether they have an entry in the emt table yet, we use a left join.
But. From within PHP, I don't get any of the columns from the emt table in my query.
Anybody know if this is a php bug or a postgresql bug? I can always write this as an ugly union (I've done it before, I've been using postgresql since 6.4 or so) but I'd rather not do it unless I have to.
(versions: pgsql 7.1.3, apache 1.3.14 through 20, php 4.0.6)
When I use this query in a psql monitor, it works fine, and returns the columns from both phonebook and emt.
select * from phonebook left join emt using (enum) where cbcpr='T' or cbemt='T';
phonebook is a huge ugly catchall table, while emt has the hours, and emergency contact number of Emergency medical techs and CPR folks in our company.
Since we want to list all emt/cpr folks whether they have an entry in the emt table yet, we use a left join.
But. From within PHP, I don't get any of the columns from the emt table in my query.
Anybody know if this is a php bug or a postgresql bug? I can always write this as an ugly union (I've done it before, I've been using postgresql since 6.4 or so) but I'd rather not do it unless I have to.