Select statement question - Mailing list pgsql-novice

From ebp
Subject Select statement question
Date
Msg-id 000d01c1c237$6ec245e0$3601a8c0@chaos
Whole thread Raw
Responses Re: Select statement question  (Doug Silver <dsilver@quantified.com>)
List pgsql-novice
Im trying to select only the first names from a table that begin with an A.
I tryed this:
select fname,lname,subscriber_id from kbeg where fname='A*'||'a*'
and no rows shows up, im positive that there are atleast 1,000 rows with fname starting with A.
Any suggestions?
 

pgsql-novice by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: select into ...outfile
Next
From: thiemo
Date:
Subject: ERD or UML tool