<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16440"></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=068044122-25012012>Deepak,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=068044122-25012012></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=068044122-25012012>Yes you can upgrage. If you are running
2011-10-06 I think you should be able to get the latest function
by</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=068044122-25012012></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=068044122-25012012>1) download the latest experimental
build</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=068044122-25012012>2) overwrite your binaries</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=068044122-25012012>3) run the postgis_upgrade_20_minor.sql and the
rtpostgis_upgrade_20_minor.sql files located in the </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=068044122-25012012>share/contrib/postgis-2.0 folder of the zip you
downloaded.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=068044122-25012012></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=068044122-25012012>Hope that helps,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=068044122-25012012>Regina</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=068044122-25012012><A
href="http://www.postgis.us">http://www.postgis.us</A></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=068044122-25012012></SPAN></FONT> </DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Deepak R aj Awasthi<BR><B>Sent:</B> Monday, January 23, 2012 3:29
AM<BR><B>To:</B> Deepak R aj Awasthi; PostGIS Users
Discussion<BR><B>Subject:</B> Re: [postgis-users] ST_MapAlgebraExpr()
Function<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV
style="BACKGROUND-COLOR: #fff; FONT-FAMILY: times new roman, new york, times, serif; COLOR: #000; FONT-SIZE: 12pt">
<DIV><SPAN>It means the POSTGIS I installed is the older one and it does not
support this function. Can I upgrade it having no problem with the present
data. If yes where can I get this version, I have searched the latest one but
unable to get it. </SPAN></DIV>
<DIV><SPAN><BR></SPAN></DIV>
<DIV><SPAN>Thanks </SPAN></DIV>
<DIV><SPAN>Regards </SPAN></DIV>
<DIV>Deepak</DIV>
<DIV
style="FONT-FAMILY: 'times new roman', 'new york', times, serif; FONT-SIZE: 12pt">
<DIV
style="FONT-FAMILY: 'times new roman', 'new york', times, serif; FONT-SIZE: 12pt">
<DIV dir=ltr><FONT size=2 face=Arial>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Deepak R aj Awasthi
<deepakrajawasthi@yahoo.com><BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> PostGIS Users Discussion
<postgis-users@postgis.refractions.net> <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, 23 January 2012,
9:24<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re:
[postgis-users] ST_MapAlgebraExpr() Function<BR></FONT></DIV><BR>
<DIV id=yiv312878869>
<DIV>
<DIV
style="BACKGROUND-COLOR: rgb(255,255,255); FONT-FAMILY: 'times new roman', 'new york', times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 12pt">
<DIV><SPAN><FONT size=3>Thanks for suggestion, I have checked the date and it
is</FONT><FONT color=#0000ff size=2 face=Arial> "2011-10-06 08:02:01".
What could be other problem can you please.. </FONT></SPAN></DIV>
<DIV style="FONT-FAMILY: times, serif; FONT-SIZE: 12pt"><BR></DIV>
<DIV style="FONT-FAMILY: times, serif; FONT-SIZE: 12pt">
<DIV style="FONT-FAMILY: times, serif; FONT-SIZE: 12pt">
<DIV dir=ltr><FONT size=2 face=Arial>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Paragon Corporation
<lr@pcorp.us><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
'PostGIS Users Discussion' <postgis-users@postgis.refractions.net>
<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, 23 January
2012, 4:57<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re:
[postgis-users] ST_MapAlgebraExpr() Function<BR></FONT></DIV><BR>
<DIV id=yiv312878869>
<DIV>
<DIV dir=ltr align=left><SPAN class=yiv312878869-23012012><FONT color=#0000ff
size=2 face=Arial>Hmm I meant 2012-01-01</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=yiv312878869OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Paragon Corporation<BR><B>Sent:</B> Sunday, January 22, 2012 10:48
PM<BR><B>To:</B> 'PostGIS Users Discussion'<BR><B>Subject:</B> Re:
[postgis-users] ST_MapAlgebraExpr() Function<BR></FONT><BR></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=yiv312878869-23012012>Just tried it on my latest build which is about
a week old (a little newer than the windows build currently on site but much
older than when this doc section was written). Works fine for
me.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=yiv312878869-23012012></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=yiv312878869-23012012>Which version of PostGIS are you
using?</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=yiv312878869-23012012></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=yiv312878869-23012012>Run this command:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=yiv312878869-23012012> select postgis_scripts_build_date(),
postgis_raster_lib_build_date();</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=yiv312878869-23012012></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=yiv312878869-23012012>Make sure both return a value later than
2011-01-01</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=yiv312878869-23012012></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=yiv312878869-23012012>Hope that helps,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=yiv312878869-23012012>Regina</SPAN></FONT></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=yiv312878869OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Deepak R aj Awasthi<BR><B>Sent:</B> Sunday, January 22, 2012 12:13
PM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] ST_MapAlgebraExpr() Function<BR></FONT><BR></DIV>
<DIV
style="BACKGROUND-COLOR: rgb(255,255,255); FONT-FAMILY: times, serif; COLOR: rgb(0,0,0); FONT-SIZE: 12pt">
<DIV>
<DIV><SPAN
style="FONT-FAMILY: times, serif; FONT-SIZE: 12pt">Hello,</SPAN><BR></DIV>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565854>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565861>
<DIV id=yiv312878869>
<DIV>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565869>
<DIV style="FONT-FAMILY: times, serif; FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565879>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565881><BR>I am a M.Sc. student
and currently working with postgreSQL/PostGIS to handle raster.
I have installed PostgreSQl 9.0 and PostGIS 2.0 in
windows 7 home premium OS. I had no problem on
handling raster so far but now I got problem while accessing
ST_MapAlgebraExpr () function which takes two rasters as
function arguments. I have followed the example provided in the link
below as follows.</DIV>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565881><BR></DIV>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565881>First, I create the table
as given,</DIV>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565881><BR></DIV>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565881><PRE style="BORDER-BOTTOM: rgb(247,147,30) 2px solid; BORDER-LEFT: rgb(247,147,30) 0px solid; PADDING-BOTTOM: 10px; LINE-HEIGHT: 16px; MARGIN-TOP: 10px; PADDING-LEFT: 10px; PADDING-RIGHT: 10px; FONT-FAMILY: Courier, Monaco, monospace; MARGIN-BOTTOM: 10px; COLOR: rgb(46,46,46); FONT-SIZE: 11px; BORDER-TOP: rgb(247,147,30) 2px solid; BORDER-RIGHT: rgb(247,147,30) 0px solid; PADDING-TOP: 10px" class=yiv312878869programlisting>CREATE TABLE fun_shapes(rid serial PRIMARY KEY, fun_name text, rast raster);</PRE>Then,
the second syntax to insert raster and finally the use of the function
ST_MapAlgebraExpr() as.</DIV>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565881><PRE style="BORDER-BOTTOM: rgb(247,147,30) 2px solid; BORDER-LEFT: rgb(247,147,30) 0px solid; PADDING-BOTTOM: 10px; LINE-HEIGHT: 16px; MARGIN-TOP: 10px; PADDING-LEFT: 10px; PADDING-RIGHT: 10px; FONT-FAMILY: Courier, Monaco, monospace; MARGIN-BOTTOM: 10px; COLOR: rgb(46,46,46); FONT-SIZE: 11px; BORDER-TOP: rgb(247,147,30) 2px solid; BORDER-RIGHT: rgb(247,147,30) 0px solid; PADDING-TOP: 10px" class=yiv312878869programlisting>SELECT ST_MapAlgebraExpr(
area.rast, bub.rast, 'rast2', '8BUI', 'INTERSECTION', 'rast2', 'rast1') As interrast,
ST_MapAlgebraExpr(
area.rast, bub.rast, 'rast2', '8BUI', 'UNION', 'rast2', 'rast1') As unionrast
FROM
(SELECT rast FROM fun_shapes WHERE
fun_name = 'area') As area
CROSS JOIN (SELECT rast
FROM fun_shapes WHERE
fun_name = 'rand bubbles') As bub</PRE></DIV>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565881><SPAN
style="FONT-SIZE: 12pt"></SPAN><BR> </DIV>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565881> <A
href="http://postgis.refractions.net/documentation/manual-svn/RT_ST_MapAlgebraExpr2.html"
rel=nofollow
target=_blank>http://postgis.refractions.net/documentation/manual-svn/RT_ST_MapAlgebraExpr2.html</A><BR><BR></DIV>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565881>But I got error on using
this syntax as:<BR><BR>ERROR: function st_mapalgebraexpr(raster,
raster, unknown, unknown, unknown, unknown, unknown) does not
exist<BR> LINE 58: SELECT
ST_MapAlgebraExpr()<BR> HINT: No function matches
the given name and argument types. You might need to add explicit
type casts.<BR><SPAN style="FONT-SIZE: 12pt"><BR></SPAN></DIV>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565881><SPAN
style="FONT-SIZE: 12pt"> Although I am new to this database, I think
that there is problem with </SPAN><SPAN
style="FONT-SIZE: 12pt"> PostGIS 2.0 to support the function. If this
the case which version I have </SPAN><SPAN
style="FONT-SIZE: 12pt"> to install to use this function. Can anyone
provide me solution for it.</SPAN></DIV>
<DIV style="FONT-SIZE: 12pt"
class=yiv312878869yui_3_2_0_22_132725134565881><BR> Thanks<BR><BR> With
Best
Regards,<BR> Deepak<BR><BR></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></BLOCKQUOTE></BLOCKQUOTE></DIV></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A href="mailto:postgis-users@postgis.refractions.net"
rel=nofollow target=_blank
ymailto="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
rel=nofollow
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR><BR></DIV></DIV></DIV></DIV></DIV><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A href="mailto:postgis-users@postgis.refractions.net"
ymailto="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR><BR></DIV></DIV></DIV></BLOCKQUOTE></BODY></HTML>