[postgis-users] insert empty geometry

[strk at refractions.net]

Empty geometry: GeomFromText('GEOMETRYCOLLECTION EMPTY', 4269);

\N is copy-format for NULL,
INSERT INTO ... VALUES(NULL) -- would be equivalent for insert

It is more likely that you want to use NULL, or
table constraints will probably fail (this is something
we should look soon or later).

--strk;

On Wed, Nov 30, 2005 at 03:12:35PM -0500, Mark Fenbers wrote:
> What's the trick to inserting an empty geometry?  I tried several 
> "guesses", like:
> 
> INSERT INTO gisfop(the_geom) VALUES( GeomFromText( 'MULTIPOLYGON((()))', 
> 4269 ) );
> 
> and other variations.  None of my guesses work, including 
> ...VALUES('\N');  What's the correct way?
> 
> Mark
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for open standards
  X     No HTML/RTF in email
 / \    No M$ Word docs in email