[ale] postgresql

[James P. Kinney III]

On Thu, 2003-11-06 at 16:13, David Hamm wrote:
> 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?

Check the name of the field with \d  I suspect that st is incorrect.

If it's there, then :

select * from companies where companies.st like 'ga'; 

should work.
> 
>  
> 
> 
> 
> ______________________________________________________________________
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
-- 
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part