[GRASSLIST:655] Re: Postgresql query

[Glynn Clements]

JDougherty wrote:

> I want to run a d.site.pg query that involes an 'OR' in the 
> 'where' field.  Ideally it should be something like:
> 
> 	select * from <table_name> where atr='A' or atr='B';
> 
> The above works from within PostgreSQL.  d.site.pg however reports 
> that 'OR' is not a valid option and that atr is not a valid 
> parameter.  I am running GRASS 5.0.3 CVS and PostgreSQL 7.3.2.

If an option value contains spaces, you need to use quotes, e.g.

	d.site.pg ... where="atr='A' or atr='B'"

-- 
Glynn Clements <glynn.clements at virgin.net>