Re: [BUGS] Problem with sql

2001-06-04 Thread Stephan Szabo
I do not see this (using fairly random table creations since you didn't provide the schema) in 7.2devel. I get 7 and 7 at the end. Which 7.1 are you using? Have you tried upgrading to 7.1.2? In any case, a script to create the tables and views and populate them with the appropriate data wou

Re: [BUGS] Problem with sql

2001-06-04 Thread Tom Lane
shashi ahuja <[EMAIL PROTECTED]> writes: >Now wht happen is in my final query of test1 and test2, "total_message" and >"con_phone" both > the columns output is changed by 5 times which is a random value. Would you mind providing this example in the form of a psql script that reproduces

[BUGS] Problem with sql

2001-06-04 Thread shashi ahuja
i have four same tables in postgres and oracle.I'm using the postgres 7.1 version. listed below GROUPSMS=# select * from group_smu_trans ; sub_id | con_phone | message | +--+---