Hi,
I have written a function to update values in a table. The table structure
is as follows:
CREATE TABLE PointAttributes(AttributeId BIGINT NOT NULL,
PointId BIGINT NOT NULL,
StrValue VARCHAR(255),
NumValue FLOAT);
Based on the attribute datatype, i have to fill up either StrValue(if
datatype is character) or NumValue(if the datatype is numeric).
My function just updates the above table by providing values. The function
is as follows:
CREATE OR REPLACE FUNCTION PP_UpdatePointParameter(varchar,varchar,text);
the first 2 parameters specify the attributename and pointname. I am passing
the value as text in the 3rd parameter.
Now if the datatype is character, i have to set the StrValue field of the
table with text value else if the datatype of the attribute is numeric then
i have to convert the text to the suitable numeric type and assign it to the
NumValue.
I have problems in doing that.....i have used TO_NUMERIC(text) as specified
in the POSTGRESQL DOCUMENTATION. When i execute the function, it says
function to_numeric("unknown") does not exist. You may need to add explicit
type casts.
And also i am not sure what the return type of my function should. I have to
just update the table.
I need help on this.
> With Best Regards
> Pradeep Kumar P J
>
>
