Message-ID: <46F59280.7050809@comcast.net>
Date: Sat, 22 Sep 2007 15:09:04 -0700
From: John Mulkerin <jmulkerin@comcast.net>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: pgsql-sql@postgresql.org
Subject: Re: Intermittent Empty return
References: <46F57BBC.8070008@comcast.net> <3838.1190493672@sss.pgh.pa.us>
In-Reply-To: <3838.1190493672@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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
>
>