Re: Postgres query problem

Yeah, I found the problem, It was adding a "order by lower(title)" in another class which I forgot about when I was trying to test the query. so it works fine now. So yep, using, joines, case, order bys, lowers,inheritance in php/postgres all work fine. 1LT John W. Holmes wrote:

Double check that you have a.title, and not just title by itself. Two tables must have a title column, so make sure you specify which one you mean. ---John Holmes... ----- Original Message ----- From: "Aaron" <aarmel@netagi.com> To: <php-general@lists.php.net> Sent: Wednesday, June 12, 2002 12:40 AM Subject: [PHP] Postgres query problem

I have a sql quer like this : " select a.title AS bugga, b.id AS asdf FROM tableone AS a FULL JOIN tabletwo AS b ON(a.title=b.filething)" anyway, thats a test query which is slightly smaller then the one I want. BUT when i use it from the command console in postgres, it works no problem but in php it complains about ambiguos column "title"...... so I dont know what I can do about it. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php