From: operationsengineer1@yahoo.com
To: Richard Broersma Jr <rabroersma@yahoo.com>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: How To Exclude True Values
Date: Wed, 7 Jun 2006 16:29:28 -0700 (PDT)
Message-ID: <20060607232928.51859.qmail@web33310.mail.mud.yahoo.com> (raw)
In-Reply-To: <20060607202551.45517.qmail@web31814.mail.mud.yahoo.com>
> > Richard,
> >
> > i got the expected rewsults! now i just have to
> study
> > the query to figure out what it does. -lol-
> >
> > i tried using AS, but i only did it in one place -
> > doh! the error message just moved to the next
> place i
> > didn't do it. i'll know better next time.
> >
> > thanks for the help.
>
> I am surprised that the query did not work the first
> time without the optional AS keyword. I
> would be interested in knowing why your server
> requires the AS and mine doesn't.
my dev box is winxp home with pgsql 8.1.3 (i think it
is .3, anyway). if platform issues don't expain it,
then i don't know what it is.
i think i've figured out the gist of the thought
process behind the SQL query...
1. select everything from t_inspect_result as table a
2. select max timestamp value entries in
t_inspect_result as table b
3. choose only choose those rows where the max
timestamps of table a and b are equal.
is that about it?
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
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-sql@postgresql.org
Cc: operationsengineer1@yahoo.com, rabroersma@yahoo.com
Subject: Re: How To Exclude True Values
In-Reply-To: <20060607232928.51859.qmail@web33310.mail.mud.yahoo.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