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 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?
That's because what it's doing it running this:
select * from table select * from table;
i.e. it's seeing the first one you typed without the semicolon then
second one too.
You'll notice the prompt looks like this;
dbname => select * from table
dbname -> select * from table;
notice the -> That means there's already something in the buffer.
\r resets the buffer. Just try it with ONLY the semicolon and it'll work.
and yeah, get to work on that upgrade... :)
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
