DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=BKP0B+lf7aK0InxdJqwzcfovoQ5eDyB+4woehymIcnGe1z6sQR6ThbzjHo61rGTMEMVw8ZoJOpMMg9fw9b4FvLRsnVbFsXDq2Xaps+Eg1g+G8xXW1cjwrBphTbOUIHMLHfpu9IeY/+C5RVMB3Iydggve4sKjquXgU2WuCEGkD1A=
	;
Message-ID: <20060607200736.6320.qmail@web31801.mail.mud.yahoo.com>
Date: Wed, 7 Jun 2006 13:07:36 -0700 (PDT)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: How To Exclude True Values
To: operationsengineer1@yahoo.com,
	"pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
In-Reply-To: <20060607192516.58324.qmail@web33303.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

> yields the following error:
> 
> ERROR:  schema "a" does not exist
> 
> i tried to interpret you query and apply it to my
> case, but, apparently, i didn't too good of a job.
> 
> do you see the error?

Hmmm... That is strange.  but according to the PostgreSQL documentation on select you can add the
option [AS] keyword  between the table_name and alias.

http://www.postgresql.org/docs/8.1/interactive/sql-select.html
    [ ONLY ] table_name [ * ] [ [ AS ] alias [ ( column_alias [, ...] ) ] ]

    ( select ) [ AS ] alias [ ( column_alias [, ...] ) ]

select a.inspect_id, a.inspect_result_id, 
       a.inspect_result_pass, 
       a.inspect_result_timestamp
from t_inspect_result AS a 

join
(
select max(t_inspect_result.inspect_result_timestamp) 
       as mstamp, 
       t_inspect_result.inspect_id
from t_inspect_result
group by t_inspect_result.inspect_id
) AS b

on a.inspect_result_timestamp = b.mstamp
;

Regards,

Richard Broersma Jr.