Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

it seems I am having a problem with ST_Split function. I am trying the following but it does not work. Can anyone spot any problems with the syntax?

select ST_Split(
   ST_GeomFromText('LINESTRING(-3.164154576738156 55.926335330437809,-3.16323392764116 55.926283382919387)'),
   ST_GeomFromText('LINESTRING(-3.16348554978961 55.92654456162947,-3.163507914241407 55.926112217812459)'));

I have tried some more sql (incl the examples in postgis docs) with st_split and it does not seem to work... Thanks in advance!

share|improve this question
Do you get an error message? "Does not work" is not a problem description. – underdark Dec 28 '11 at 20:43
Hi, I am sorry I forgot to add the error. ERROR: function st_split(geometry, geometry) does not exist LINE 1: select ST_Split( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. – Antony Dec 29 '11 at 10:07
up vote 5 down vote accepted

st_split is a function for PostGIS 2.0 or above. Maybe you are using a previous version of PostGIS

You can check which version of PostGIS are you using with:

SELECT PostGIS_full_version();
share|improve this answer
Yes, I was using 1.4 Thank you for your answer. – Antony Dec 29 '11 at 10:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.