[SQL] Intermittent Empty return

2007-09-22 Thread John Mulkerin
I'm new to Postgres. I'm trying to select data from my survey_results table. My server is running Postgres 7.3.4. 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 dat

Re: [SQL] Intermittent Empty return

2007-09-22 Thread Tom Lane
John Mulkerin <[EMAIL PROTECTED]> 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_n

Re: [SQL] Intermittent Empty return

2007-09-22 Thread John Mulkerin
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; ER

Re: [SQL] Intermittent Empty return

2007-09-22 Thread Scott Marlowe
On 9/22/07, John Mulkerin <[EMAIL PROTECTED]> wrote: > 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 resul