[ale] postgresql

[David Hamm]

Found it.  Don't know how I managed this.  Maybe from moving between gui
and command line but I managed to create the table with double quotes
around each field name.  So there was no st there was an "st".  A quick
drop and recreate of the table fixed the problem.  Thanks for the
suggestions.
 
David Hamm
Spinnerdog Inc
#250 1029 Peachtree Parkway
Peachtree City, GA 30269
www.spinnerdog.com
[voice] 770-631-1329
[fax] 770-632-0613
 
 
-----Original Message-----
From: ale-bounces at ale.org [mailto:ale-bounces at ale.org] On Behalf Of
David Hamm
Sent: Thursday, November 06, 2003 4:14 PM
To: ale at ale.org
Subject: [ale] postgresql
 
Just beginning  to work with postgresql and can't figure this one out.
I a simple name and address table called companies.  When "select * from
companies" all records are listed.  But when I try to use a where clause
I get an "Attribute not found" error.  Here is the query "select * from
companies where st like ga" which returns "Attribute st nof found".
I've also tried using this query "select * from companies where
companies.st like 'ga'" and it returns the same error.  And st is one of
the fields.  Any suggestions?
 
-------------- next part --------------
An HTML attachment was scrubbed...