From: | "Doran L(dot) Barton" <fozz(at)iodynamics(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | equal: don't know whether nodes of type 719 are equal |
Date: | 1999-10-07 16:36:28 |
Message-ID: | 19991007103628.A15675@iodynamics.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm getting this message in my log files. It's a warning being generated
when I submit a specific query to Postgres. Here's the Perl/DBI code that
submits the query:
$sth = $self->{dbh}->prepare(
"select distinct event.* from \
event, u_participant, group_user, g_participant where \
event.t_begin >= '$date 0:00' and \
event.t_end <= '$date 23:59' and \
(g_participant.event_id = event.event_id and \
g_participant.group_id = group_user.group_id and \
group_user.username = varchar '$username') \
union
select distinct event.* from \
event, u_participant, group_user, g_participant where \
event.t_begin >= '$date 0:00' and \
event.t_end <= '$date 23:59' and \
(u_participant.event_id = event.event_id and \
u_participant.username = varchar '$username')");
$rv = $sth->execute;
event_id and group_id are all int4.
username is varchar(10).
t_begin and t_end are datetime.
I know the message is ONLY a warning... but I'd like to know what it's
warning me about.
-=Fozz
--
Doran L. Barton <fozz(at)iodynamics(dot)com>
Iodynamics LLC -- "Internetworking the masses"
<URL:http://www.iodynamics.com/>
From | Date | Subject | |
---|---|---|---|
Next Message | Anand Surelia | 1999-10-07 16:37:11 | Re: [GENERAL] Foreign Key |
Previous Message | Bruce Momjian | 1999-10-07 16:16:56 | Re: [GENERAL] what does this mean - pg_psort.1922.0 in database directory?] |