agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedweird select results
3+ messages / 2 participants
[nested] [flat]
* weird select results
@ 1995-07-12 06:02 Casey Claiborne <mskc@io.com>
1995-07-12 14:18 ` Re: weird select results Stefan Golder <golder@informatik.uni-wuerzburg.de>
0 siblings, 1 reply; 3+ messages in thread
From: Casey Claiborne @ 1995-07-12 06:02 UTC (permalink / raw)
To: legacy
Hello -
I have a database that I created. I added data to it (that works). I
then try the first query:
retrieve (info.all)
that brings up everything fine
------ 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
This is just a simple select statement. I do not understand why it fails to
return data :(
What is wrong with what I am doing?
Casey Claiborne mskc@io.com
One must note the importance of setting reasonable and achievable goals for
"If you aim for nothing, you'll hit it every time"
==============================================================================
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: weird select results
1995-07-12 06:02 weird select results Casey Claiborne <mskc@io.com>
@ 1995-07-12 14:18 ` Stefan Golder <golder@informatik.uni-wuerzburg.de>
0 siblings, 0 replies; 3+ messages in thread
From: Stefan Golder @ 1995-07-12 14:18 UTC (permalink / raw)
To: legacy
> ------ 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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: weird select results
@ 1995-07-13 10:28 Casey Claiborne <mskc@io.com>
0 siblings, 0 replies; 3+ messages in thread
From: Casey Claiborne @ 1995-07-13 10:28 UTC (permalink / raw)
To: Stefan Golder <golder@informatik.uni-wuerzburg.de>; legacy
Thank you for responding, that was the problem
At 04:18 PM 7/12/95 DST), Stefan Golder wrote:
>> ------ 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/
>
>
Casey Claiborne mskc@io.com
One must note the importance of setting reasonable and achievable goals for
"If you aim for nothing, you'll hit it every time"
-Theodore Roosevelt
==============================================================================
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1995-07-13 10:28 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1995-07-12 06:02 weird select results Casey Claiborne <mskc@io.com>
1995-07-12 14:18 ` Stefan Golder <golder@informatik.uni-wuerzburg.de>
1995-07-13 10:28 Re: weird select results Casey Claiborne <mskc@io.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox