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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] Is the fix for > 2GB files already in 6.5.3?
Следующее
От: Manuel Cabido
Дата:
Сообщение: Re: pgsql-general-digest V1 #614