[SQL] Can't postgres join tables on varchar fields ?
Hi!!, -- Best regards, Gurudutt mailto:[EMAIL PROTECTED] Life is not fair - get used to it. Bill Gates ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[SQL] PEAR Problem
Hi, It's me again. I have been able to solve most of the porting problems from mysql to pgsql. But I have got struck in one place. I have a problem where PEAR's associative array doesn't recognise the mix case letters. eg . I issue a query through PEAR db and get results using fetchRow of PEAR. Now I have set associative array feature ON. suppose the query is select NetCode,NetworkName from NetworkTab; this would return the result into a variable called $dbRow to echo the contents returned by the pgsql, I have to give $dbRow[NetCode] and $dbRow[NetworkName] This used to work perfectly fine with mysql, but as I moved to pgsql, PEAR started to return nothing like if i echo $dbRow[NetCode] it prints nothing but in the same echo is I change it echo $dbRow[netcode], it prints the value of the Network Code. How do I handle this situation. The application is fully written with Mix Case letters for the database fields and returned result set. And one more thing "SET AUTOCOMMIT=0" which is to set auto commiting to "No" in mysql doesn't work in pgsql what is the equivalent command. -- Best regards, Gurudutt mailto:[EMAIL PROTECTED] Life is not fair - get used to it. Bill Gates ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[SQL] Need Help!!
Hello pgsql-sql, I am the new member for the postgres mailing list. Actually I have been working with mysql, php and perl for a very long time now, and offlate shifted to pgsql. I have many technical difficulties 1. I need to port mysql data to pgsql. I tried both mysql2pg.pl and my2pg.sql. Both have some problem. I think it is got something to do with the auto increment feature that i used in mysql. Can that issue be addressed while porting. 2. Some of the joins that were successfully working in mysql are not working, most importantly LEFT JOIN. eg. SELECT SUM(ACT_DueTab.CableAmount) as NetworkTotal FROM ACT_NetworkTab,ACT_DueTab, ACT_InvoiceTab LEFT JOIN ACT_CustomerTab ON (ACT_CustomerTab.CustCode=ACT_InvoiceTab.CustCode) WHERE ACT_DueTab.InvCode=ACT_InvoiceTab.InvNumber and ACT_NetworkTab.NetCode=3 and ACT_CustomerTab.NetCode=ACT_NetworkTab.NetCode and (ACT_InvoiceTab.InvGenDate <= '2001-08-31' and ACT_InvoiceTab.InvGenDate >= '2001-08-01') ORDER BY ACT_InvoiceTab.InvGenDate DESC This query works fine in mysql, but suffers in pgsql. 3. I was using PEAR for data abstraction layer ( to make code independent of the database), I find that PEAR which worked fine with mysql doesn't work so well with pgsql Any help on all these issues will be greatly appreciated. I am in the midst of a porject porting exercise. -- Best regards, Gurudutt mailto:[EMAIL PROTECTED] Life is not fair - get used to it. Bill Gates ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
