Re: Intermittent Empty return

I agree its old.   I'm working on the upgrade but first need to verify 
and then purge some data. 

I tried with and without a semicolon

However, with a semicolon results in

Just tried semicolon again..   First time resulted in results.  Second 
time resulted in
select * from survey_results;
ERROR:  parser: parse error at or near "select" at character 30.
Maybe another reason I need to upgrade?

Tom Lane wrote:
> John Mulkerin <jmulkerin@comcast.net> writes:
>   
>> I'm new to Postgres.  I'm trying to select data from my survey_results 
>> table.   My server is running Postgres 7.3.4.
>>     
>
> Do you realize how ancient that version is?  An update would be a
> real good idea.
>
>   
>> I log in as root (its RH), then
>> psql database_name.   Its says "Welcome..... ". I then type "SELECT * 
>> from survey_results" and hit enter. Nothing!  It just goes back to the 
>> database_name prompt.
>>     
>
> It sounds like you've forgotten to end the command with a semicolon.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>