[SQL] polygon overlay

2010-08-31 Thread Gary Fu
Hi, I don't see any overlap between the polygon and the box in the following sql. Can anyone explain why it returns 't'? select polygon(path '((0,0),(10,10),(20,10),(10,0))') && polygon(box '((16,0),(17,1))'); ?column? -- t (1 row) Thanks, Gary -- Sent via pgsql-sql mailing list

Re: [SQL] PostGres Tables in ArcSDE and ArcCatalog.

2010-08-31 Thread Michael Andrew Babb
Hi Scott, Of all things, ArcSDE does not like tables with names consisting of mixed case letters. In addition, ArcSDE does not like field names consisting of mixed case letters. I changed the case of the field names and table names to all lowercase and ArcCatalog could see the tables just fine