[postgis-users] proper spatial table ?

[Obe, Regina]

Actually I think Dorothy can have her way though she probably shouldn't.
true  and false are overloaded.

Try these for example

select true = 't', false = 'f', true = 'f', true ='true', false =
'false', true = 'false', false = 'true'

Maybe you have your contains backwards - try the below

select a.cat as hey_no,b.cat,b.yuk,b.wkb_geometry
from shey6 as a,sel10p4 as b where contains 
 (b.wkb_geometry,a.wkb_geometry) = 't'


You can leave out the 't' its redundant anyway but in other systems it
is bizarrely required because they don't have real booleans.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Monday, October 01, 2007 10:47 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] proper spatial table ?

That's right, you aren't in Oracle anymore, Dorothy. :)

Boolean functions return... a boolean! Not a 't' or 'f'.

P

On 1-Oct-07, at 6:05 AM, Stephen Woodbridge wrote:

> temiz wrote:
>> hello
>> I created I spatial table from another table.
>> But I am not sure that new table is a proper spatial table.
>> I created it in usual way like this:
>> create table hey_yuk1 as
>> select a.cat as hey_no,b.cat,b.yuk,b.wkb_geometry
>> from shey6 as a,sel10p4 as b where contains 
>> (a.wkb_geometry,b.wkb_geometry) ='t'
>> what is the wrong ?
>
> try without the ='t'
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.