--Apple-Mail-23-449783753
Content-Type: text/plain;
charset=US-ASCII;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit
Hi there,
it seems to work with 8.1, but not anymore with 8.3. What is wrong
with this substring request? Or is it some installation issue? Thanks
for any suggestion!
SELECT substring(date from 1 for 7) AS stryearmonth, COUNT(id) AS
countofnumber FROM (SELECT * from downloads ) AS foo GROUP BY
stryearmonth ORDER BY stryearmonth ASC
It says:
ERROR: function pg_catalog.substring(date, integer, integer) does not
exist
LINE 1: SELECT substring(date from 1 for 7) as stryearmonth, COUNT(i...
--Apple-Mail-23-449783753
Content-Type: text/html;
charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
<html><body style=3D"word-wrap: break-word; -webkit-nbsp-mode: space; =
-webkit-line-break: after-white-space; "><span class=3D"Apple-style-span"
=
style=3D"font-family: arial; font-size: 13px; =
-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: =
2px; "><pre class=3D"data" style=3D"font-family: arial, tahoma, verdana, =
helvetica, sans-serif, serif; font-size: 100%; "><font =
class=3D"Apple-style-span" color=3D"#666666" face=3D"verdana" =
size=3D"3"><span class=3D"Apple-style-span" style=3D"font-size: 11px; =
white-space: normal; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px;">Hi there,</span></font></pre><pre =
class=3D"data" style=3D""><font class=3D"Apple-style-span" =
color=3D"#666666" face=3D"verdana" size=3D"3"><span =
class=3D"Apple-style-span" style=3D"font-size: 11px; white-space: =
normal; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px;">it seems to work with 8.1, but =
not anymore with 8.3. What is wrong with this substring request? Or is =
it some installation issue? Thanks for any =
suggestion!</span></font></pre><pre class=3D"data" style=3D"font-family: =
arial, tahoma, verdana, helvetica, sans-serif, serif; font-size: 100%; =
"><span class=3D"Apple-style-span" style=3D"color: rgb(102, 102, 102); =
font-family: verdana; font-size: 11px; white-space: normal; =
-webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: =
0px; ">SELECT substring(date from 1 for 7) AS stryearmonth, COUNT(id) AS =
countofnumber FROM (SELECT * from downloads ) AS foo GROUP BY =
stryearmonth ORDER BY stryearmonth ASC</span></pre><pre class=3D"data" =
style=3D"font-family: arial, tahoma, verdana, helvetica, sans-serif, =
serif; font-size: 100%; "><font class=3D"Apple-style-span" =
color=3D"#666666" face=3D"verdana" size=3D"3"><span =
class=3D"Apple-style-span" style=3D"font-size: 11px; white-space: =
normal; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px;">It says:</span></font></pre><pre =
class=3D"data" style=3D"font-family: arial, tahoma, verdana, helvetica, =
sans-serif, serif; font-size: 100%; "><font class=3D"Apple-style-span" =
color=3D"#666666" face=3D"verdana" size=3D"3"><span =
class=3D"Apple-style-span" style=3D"font-size: 11px; white-space: =
normal; -webkit-border-horizontal-spacing: 0px; =
-webkit-border-vertical-spacing: 0px;"><span class=3D"Apple-style-span" =
style=3D"color: rgb(0, 0, 0); font-family: arial; font-size: 13px; =
-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: =
2px; "><pre class=3D"data" style=3D"font-family: arial, tahoma, verdana, =
helvetica, sans-serif, serif; font-size: 100%; ">ERROR: function =
pg_catalog.substring(date, integer, integer) does not exist
LINE 1: SELECT substring(date from 1 for 7) as stryearmonth, =
COUNT(i...</pre></span></span></font></pre></span></body></html>=
--Apple-Mail-23-449783753--
|
