Re: [Treebase-devel] Bad query in treebase-web app?

[Hilmar L. <hl...@ne...>]

On Feb 8, 2010, at 3:37 PM, Jon Auman wrote:

> Look at the tail end of the query
> TAXON_ID=$1
> Can that be right ???

Yes. $1 is a parameter placeholder. If PostgreSQL were really trying  
to parse $1 as the literal SQL, it would generate a parse error.

If the query runs excessively long, it's an indication for a missing  
index or a query execution plan that is poor for some other reason.

	-hilmar

-- 
===========================================================
: Hilmar Lapp  -:- Durham, NC -:- informatics.nescent.org :
===========================================================