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,
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
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
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
pgsql-novice by date
|Next:||From: Devrim GUNDUZ||Date: 2004-07-26 07:26:55|
|Subject: Re: Load Balancing / Failover cluster|
|Previous:||From: Devrim GUNDUZ||Date: 2004-07-26 05:23:30|
|Subject: Re: Request for information about 3rd party support for|