Ok, this is odd... I tried ending with a semicolon before, and received this error ERROR: parser: parse error at or near "select" I have to do it twice before I get it works...here's an example select project_name from project_group_list; ERROR: parser: parse error at or near "select" select project_name from project_group_list; ... ... ... that's odd... -Jonathan <quote who="Brian Wong"> > On 7/29/05, Jonathan Villa <jvilla@xxxxxxxxxxxxxxxxxxxx> wrote: >> now I want to select >> #select someColumn from testtable >> >> I get nothing... no output, nothing... > > Try terminating the statement with ';'? > ---------------------------(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