Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id HAA19155 for postgres-redist; Wed, 12 Jul 1995 07:18:54 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199507121418.HAA19155@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from wrzx01.rz.uni-wuerzburg.de (wrzx01.rz.uni-wuerzburg.de [132.187.1.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id HAA19145 for <postgres@postgres.berkeley.edu>; Wed, 12 Jul 1995 07:18:46 -0700
Received: from wi2x25.informatik.uni-wuerzburg.de by wrzx01.rz.uni-wuerzburg.de (4.1/uniwue-M-3.2)
	id AA11928; Wed, 12 Jul 95 16:18:32 +0200
Received: by wi2x25.informatik.uni-wuerzburg.de (5.65v3.0/uniwue-C-3.2)
	id AA01953; Wed, 12 Jul 1995 16:18:31 +0200
From: Stefan Golder <golder@informatik.uni-wuerzburg.de>
Message-Id: <9507121418.AA01953@wi2x25.informatik.uni-wuerzburg.de>
Subject: Re: weird select results
To: postgres@postgres.Berkeley.EDU (postgres)
Date: Wed, 12 Jul 1995 16:18:31 +0200 (MET DST)
In-Reply-To: <199507120602.BAA00439@tristero.io.com> from "Casey Claiborne" at Jul 12, 95 01:02:05 am
X-Mailer: ELM [version 2.4 PL23]
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 428       
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Wed, 12 Jul 95 07:18:54 -0700
Resent-XMts: smtp

>         ------ BUT -----
> 
> when I try 
> 
>         retrieve (info.all) where name="casey"
> 
> I get the following error:
>         
>         WARN: Jul 12 00:26:12: type_id lookup of 362 failed

You've just forgotten to insert the class on which you run your query in front of the attribute name.
The right query string is

	retrieve (info.all) where info.name="casey"


Stefan Golder
golder@informatik.uni-wuerzburg.de


==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/