On Thu, Sep 29, 2005 at 10:04:04PM -0500, Steve Peterson wrote: > Is this a bug or some artifact of the SQL language that I've never > seen before? > > SELECT v_id > FROM table > WHERE col = 'V') > AND blah > > executes without errors, ignoring the closing paren and everything > thereafter.
Not here. How are you executing that query, exactly? -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 17.7", W 73º 14' 26.8" "Some men are heterosexual, and some are bisexual, and some men don't think about sex at all... they become lawyers" (Woody Allen) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend