is this a bug?
От | John Henderson |
---|---|
Тема | is this a bug? |
Дата | |
Msg-id | 001f01bf66c3$868237c0$ea7c3eca@john.is.com.fj обсуждение исходный текст |
Список | pgsql-general |
Hi all, Using PostgreSQL 6.4 on BSD/OS 3.0 Is this a bug? Otherwise what am I doing wrong? isfiji=> \q moe:~ $ psql isfiji Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL type \? for help on slash commands type \q to quit type \g or terminate with semicolon to execute query You are currently connected to the database: isfiji isfiji=> select a.sess_id,b.sess_id,a.user_name,b.user_name, isfiji-> a.nas_ip,b.nas_ip,a.port,b.port from startrecs a,stoprecs b isfiji-> where a.nas_ip=b.nas_ip isfiji-> and a.sess_id=b.sess_id isfiji-> and a.user_name=b.user_name; sess_id |sess_id |user_name |user_name | nas_ip| nas_ip|port|port --------+--------+--------------+--------------+-------+-------+----+---- 000050E2|000050E2|rchand |rchand |0.0.0.0|0.0.0.0| 0| 0 000050E6|000050E6|dallys |dallys |0.0.0.0|0.0.0.0| 0| 0 000050E8|000050E8|sana |sana |0.0.0.0|0.0.0.0| 0| 0 000050ED|000050ED|jdjohnson |jdjohnson |0.0.0.0|0.0.0.0| 0| 0 0000509F|0000509F|ritesh |ritesh |0.0.0.0|0.0.0.0| 0| 0 000050EE|000050EE|barbara |barbara |0.0.0.0|0.0.0.0| 0| 0 000050EF|000050EF|barbara |barbara |0.0.0.0|0.0.0.0| 0| 0 000050F0|000050F0|axis |axis |0.0.0.0|0.0.0.0| 0| 0 etc..... (363 rows) isfiji=> select a.sess_id,b.sess_id,a.user_name,b.user_name, isfiji-> a.nas_ip,b.nas_ip,a.port,b.port from startrecs a,stoprecs b isfiji-> where a.sess_id=b.sess_id isfiji-> and a.user_name=b.user_name isfiji-> and a.nas_ip=b.nas_ip; sess_id|sess_id|user_name|user_name|nas_ip|nas_ip|port|port -------+-------+---------+---------+------+------+----+---- (0 rows) isfiji=> Thanks, John
В списке pgsql-general по дате отправления: