[postgis-devel] Regular expressions in PostGIS sources

Paul Ramsey pramsey at opengeo.org
Mon Nov 15 12:40:31 PST 2010


Could you give me some richer examples of the syntax in the form of
full SQL statements?

2010/11/15 Jorge Arévalo <jorge.arevalo at deimos-space.com>:
> On Mon, Nov 15, 2010 at 7:19 PM, Paul Ramsey <pramsey at opengeo.org> wrote:
>> There's some regex support in postgresql core. What do you need regex
>> for in raster?
>>
>> P
>
> Hi Paul,
>
> For MapAlgebra implementation at core level. The ST_MapAlgebra
> Pl/pgSQL function takes an input argument like "SELECT rast + 3",
> meaning "add 3 to all raster's pixels", and it calls a  core function
> (via postgresql function) to perform the operation.
>
> Should I parse the expression in PL/pgSQL function, at postgresql
> level or at core level? Now, I'm working only at core level.
>
> Thanks!
>
> --
> Jorge Arévalo
> Internet & Mobilty Division, DEIMOS
> jorge.arevalo at deimos-space.com
> http://mobility.grupodeimos.com/
> http://gis4free.wordpress.com
>
>
>>
>> 2010/11/15 Jorge Arévalo <jorge.arevalo at deimos-space.com>:
>>> Hi all,
>>>
>>> Is there any mechanism in PostGIS to deal with regular expressions and
>>> string replacement at core level (I mean, C functions)? I'm going to
>>> use string replacement in PostGIS Raster but I don't want to reinvent
>>> the wheel, if is invented
>>>
>>> Many thanks in advance,
>>>
>>> --
>>> Jorge Arévalo
>>> Internet & Mobilty Division, DEIMOS
>>> jorge.arevalo at deimos-space.com
>>> http://mobility.grupodeimos.com/
>>> http://gis4free.wordpress.com
>>> _______________________________________________
>>> postgis-devel mailing list
>>> postgis-devel at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>>>
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>



More information about the postgis-devel mailing list