pg.ddx.io pgsql-admin@postgresql.org mailing list archive help / color / mirror / Atom feed From: Scott Whitney <swhitney@journyx.com>
To: pgsql-admin@postgresql.org
Subject: Strange query problem...
Date: Wed, 28 Jan 2009 11:49:43 -0600
Message-ID: <20090128174824.B4C457E4165@mail.int.journyx.com> (raw )
Um. How is this possible? Am I doing something very, very stupid, here?
mydb=# select * from time_recs where id_time_rec not in (select id_time_rec
from punch_time_recs);
id_time_rec | id_user | record_date | id_code_task | id_code_pay_type |
id_project | time_amount | comment | commit_state | id_domain |
id_code_bill_type | id_group
-------------+---------+-------------+--------------+------------------+----
--------+-------------+---------+--------------+-----------+----------------
---+----------
(0 rows)
mydb=# select count(*) from time_recs;
count
-------
73725
(1 row)
mydb=# select count(*) from punch_time_recs;
count
-------
5369
(1 row)
There are many occurences where this is true...Roughly 68,356, if my math is
right. :)
Table definitions:
mydb=# \d time_recs
Table "public.time_recs"
Column | Type | Modifiers
-------------------+------------------------+-------------------------------
id_time_rec | character varying(38) | not null
id_user | character varying(38) | not null
record_date | character varying(38) | not null
id_code_task | character varying(38) | not null
id_code_pay_type | character varying(38) | not null
id_project | character varying(38) | not null
time_amount | double precision | not null
comment | character varying(252) | default ''::character varying
commit_state | integer | not null
id_domain | character varying(38) | not null
id_code_bill_type | character varying(38) | not null
id_group | character varying(38) | not null
Indexes:
"cpk_123" PRIMARY KEY, btree (id_time_rec)
"ix123_10" btree (id_code_bill_type)
"ix123_2" btree (record_date)
"ix123_3" btree (id_code_task)
"ix123_4" btree (id_code_pay_type)
"ix123_5" btree (id_project)
"ixc123_1_2" btree (id_user, record_date)
Foreign-key constraints:
"f123_10_112" FOREIGN KEY (id_code_bill_type) REFERENCES
codes_bill_types(id_code)
"f123_1_104" FOREIGN KEY (id_user) REFERENCES users(id_user)
"f123_3_109" FOREIGN KEY (id_code_task) REFERENCES codes_tasks(id_code)
"f123_4_111" FOREIGN KEY (id_code_pay_type) REFERENCES
codes_pay_types(id_code)
"f123_5_108" FOREIGN KEY (id_project) REFERENCES projects(id_project)
"f123_9_103" FOREIGN KEY (id_domain) REFERENCES domains(id_domain)
mydb=# \d punch_time_recs
Table "public.punch_time_recs"
Column | Type | Modifiers
-------------------+------------------------+-------------------------------
id_punch | character varying(38) | not null
id_user | character varying(38) | not null
record_date | character varying(38) | not null
id_code_task | character varying(38) | not null
id_code_pay_type | character varying(38) | not null
id_project | character varying(38) | not null
punch_datetime | double precision | not null
comment | character varying(252) | default ''::character varying
id_time_rec | character varying(38) |
when_exported | double precision |
id_code_bill_type | character varying(38) | not null
pre_or_post | double precision |
id_group | character varying(38) | not null
Indexes:
"cpk_173" PRIMARY KEY, btree (id_punch)
"ix173_10" btree (id_code_bill_type)
"ix173_3" btree (id_code_task)
"ix173_4" btree (id_code_pay_type)
"ix173_5" btree (id_project)
"ix173_6" btree (punch_datetime)
"ix173_8" btree (id_time_rec)
"ixc173_1_2" btree (id_user, record_date)
Foreign-key constraints:
"f173_10_112" FOREIGN KEY (id_code_bill_type) REFERENCES
codes_bill_types(id_code)
"f173_1_104" FOREIGN KEY (id_user) REFERENCES users(id_user)
"f173_3_109" FOREIGN KEY (id_code_task) REFERENCES codes_tasks(id_code)
"f173_4_111" FOREIGN KEY (id_code_pay_type) REFERENCES
codes_pay_types(id_code)
"f173_5_108" FOREIGN KEY (id_project) REFERENCES projects(id_project)
"f173_8_123" FOREIGN KEY (id_time_rec) REFERENCES time_recs(id_time_rec)
ON DELETE CASCADE
view thread (8+ messages) latest in thread
Message-ID: <20090128174824.B4C457E4165@mail.int.journyx.com>
Permalink: ../20090128174824.B4C457E4165@mail.int.journyx.com/
Also on: postgresql.org/message-id/20090128174824.B4C457E4165@mail.int.journyx.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: swhitney@journyx.com
Subject: Re: Strange query problem...
In-Reply-To: <20090128174824.B4C457E4165@mail.int.journyx.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox