how to make this function work....

ravysters

hi.. i have this procedure.. but its not working.. its showing some syntax errors.. how can i make this work.. please help

create or replace function test(text)
returns integer
as
$$
Declare
x varchar;
y varchar;
z varchar;
Begin
z := select xpath('/F/@CT:I',''||$1||'',ARRAY[ARRAY['CT','urn:PointCross-ChangeTracker']]);
execute z into y;
return y;
end;
$$
language 'plpgsql';

rski

Quote:

Originally Posted by ravysters

hi.. i have this procedure.. but its not working.. its showing some syntax errors.. how can i make this work.. please help

create or replace function test(text)
returns integer
as
$$
Declare
x varchar;
y varchar;
z varchar;
Begin
z := select xpath('/F/@CT:I',''||$1||'',ARRAY[ARRAY['CT','urn:PointCross-ChangeTracker']]);
execute z into y;
return y;
end;
$$
language 'plpgsql';

Maybe you'll show that errors. By the way if z is varchar shouldn't you put

Expand|Select|Wrap|Line Numbers

 
select xpath('/F/@CT:I',''||$1||'',ARRAY[ARRAY['CT','urn:PointCross-ChangeTracker']]);

between apos.

Expand|Select|Wrap|Line Numbers

 
z:='select xpath('/F/@CT:I',''||$1||'',ARRAY[ARRAY['CT','urn:PointCross-ChangeTracker']]);'

and why do you write ''||$1||'' are you using there quotation or is it double apos?

ravysters

i am sorry.. i accidentally reported instead of replying...

thanks for the reply...the function is working...

but i have a new problem.. type casting..how can i do that in postgres...
i went through the manual... but wasn't that helpful...

consider the following..

declare x varchar;
execute 'select xpath()' into x;
return x;

how can i convert x from varchar to integer...
help me..

rski

Quote:

Originally Posted by ravysters

i am sorry.. i accidentally reported instead of replying...

thanks for the reply...the function is working...

but i have a new problem.. type casting..how can i do that in postgres...
i went through the manual... but wasn't that helpful...

consider the following..

declare x varchar;
execute 'select xpath()' into x;
return x;

how can i convert x from varchar to integer...
help me..

doesn't simple

Expand|Select|Wrap|Line Numbers

return x::integer

work? if not maybe you should write your own cast function.

ravysters

hi.. even after doing that i am gettting this error..

invalid input syntax for integer: ...

i even used select cast( x as integer)..

dint work either man..

rski

Quote:

Originally Posted by ravysters

hi.. even after doing that i am gettting this error..

invalid input syntax for integer: ...

i even used select cast( x as integer)..

dint work either man..

What does

Expand|Select|Wrap|Line Numbers

execute 'select xpath()' into x;

produce?

how to make this function work....

re: how to make this function work....

re: how to make this function work....

re: how to make this function work....

re: how to make this function work....

re: how to make this function work....

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about