Re: BUG #11553: Sum function does not exist in Create View

On 10/2/2014 8:11 AM, Harry@HarryClarke.me.uk wrote:
> The following bug has been logged on the website:
>
> Bug reference:      11553
> Logged by:          Harry Clarke
> Email address:      Harry@HarryClarke.me.uk
> PostgreSQL version: 9.3.5
> Operating system:   Windows 8.1 64bit
> Description:
>
> When attempting to create a view using the following commands
> CREATE VIEW myschema.vc17_tetrad_months AS
>   SELECT mv.tetrad,
>     sum(mv.month) AS months_visited,
>     mv.the_geom
>   FROM ( SELECT
>    ...
>    ) mv
> GROUP BY mv.tetrad, mv.the_geom;;
>
> The error message
> ERROR:  function sum(text) does not exist
> LINE 5:     sum(mv.month) AS months_visited,
>              ^
> HINT:  No function matches the given name and argument types. You might need
> to add explicit type casts.
>
> is returned. However, if the function "sum" is replaced by the function
> "count". No error message is returned, and the expected result is obtained.
>
>

what datatype is mv.month ?

if its TEXT as the error says, well, you can't add strings, can you?
maybe your inner query (which you didn't show) should have returned an
INTEGER instead of text...



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast