Hi All
I'm having an issue with pgscript where a query returning a sting encases
the text in brackets and quotes. This doesn't help when trying to use the
returned text in further queries. I haven't been able to find a simple
work around so thought one of you may have a fix. Below is some script
which, for me, produces the result ("POLYGON"). All I want is POLYGON.
DECLARE @table, @geotype;
SET @table = 'table_name';
SET @geotype = SELECT GeometryType(geom) FROM @table LIMIT 1;
PRINT @geotype;
Cheers
Adrian
Notice:
This email and any attachments may contain information that is personal,
confidential, legally privileged and/or copyright.No part of it should be
reproduced,
adapted or communicated without the prior written consent of the copyright
owner.
It is the responsibility of the recipient to check for and remove viruses.
If you have received this email in error, please notify the sender by return
email, delete
it from your system and destroy any copies. You are not authorised to use,
communicate or rely on the information
contained in this email.
Please consider the environment before printing this email.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
