From: | "John Henderson" <jrh(at)is(dot)com(dot)fj> |
---|---|
To: | <pgsql-general(at)hub(dot)org> |
Subject: | is this a bug? |
Date: | 2000-01-24 23:34:14 |
Message-ID: | 001f01bf66c3$868237c0$ea7c3eca@john.is.com.fj |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-01-24 23:49:25 | Re: [GENERAL] System requirements |
Previous Message | Ed Loehr | 2000-01-24 23:33:29 | Re: [GENERAL] EndTransactionBlock error |