Re: [SQL] Intermittent Empty return

2007-09-23 Thread John Mulkerin
Thanks a lot. Scott Marlowe wrote: 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 semi

Re: [SQL] Intermittent Empty return

2007-09-22 Thread John Mulkerin
sults; ERROR: parser: parse error at or near "select" at character 30. Maybe another reason I need to upgrade? Tom Lane wrote: John Mulkerin <[EMAIL PROTECTED]> writes: I'm new to Postgres. I'm trying to select data from my survey_results table. My server is runnin

[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