ravysters
Last Activity: Mar 29 '10, 04:36 AM
Joined: May 28 '08
Location:
-
thanks for your reply.. i ll do what ever you've suggested -
Client Encoding in postgresql
hello all...
I am using postgres as my backend server and i need to insert some characters into tables... the server side encoding is UTF-8 and i am using the psqlODbc to connec to the database..
now for example if i try to insert some russian characters it inserts some '???????'
if i use the command set client encoding to UTF8, this sets the encoding to UTF-8 only for a particular session.
how do i make... -
psqlodbc
How do i get values from a function whose out parameter is a ref cursor...it works fine in pgadmin.. but i cannot get the values when i tried the function with VC++... please help -
i am still getting this error...
column "j" does not exist
LINE 1: select sam(j)Leave a comment:
-
calling functions which are stored as values in a table
hi... i have this problem... consider the following code... create or replace function sam(in j int) returns int
as
$$
declare
i int;
begin
i := 4;
i= i*j;
return i;
end;
$$
language plpgsql;
create table sam1
(
i varchar
)
insert into sam1 values('sam(j)' );
how can i call the function sam which is in the... -
Triggers in postgres
Is is neccessary to write the trigger function in order to create the trigger.. -
Return output parameters in VC++
hi... i am using VC++ to connect to my database and i am trying to insert a new row into a table. I am also using the returning statement available in postgres to return a column of the currently inserted record.. i have to output this.. can i do this.. here is my code.. i am getting an exception when i run this code.. there is no probs when i only use the insert statement.. but when i use the insert statement with the returning clause i get the... -
connection to postgres
hi.. can anyone help me with this... i have postgres as my database.. i need to connect it to VC++.... how can i do it.. can anyone give a sample code to connect to postgres using VC++.... -
Scalability issues....
hi.. i am working on a project, the specifications of which include postgresql as the database.. mostly i ll be using the XML feature of postgres...
so..can u guys give me the scalability issues associated with the functions of xml in postgres...
i need to know how much load each function can take.. does it crash.... or give me ur comments about it..
thanks in advance for any posts -
yes i was... give me some names who use postgres in their applications... .Leave a comment:
-
Customers of PostgreSQL
hi... i need to know the names of the customers using postgres as their database in their applications... please help me by specifying them..
thanks for any posts -
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..Leave a comment:
-
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...Leave a comment:
-
how to make this function work....
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:Point Cross-ChangeTracker']]);
execute z into y;... -
so... its not possible with 8.3.1????Leave a comment:
-
the question is...
just like
EXECUTE statement USING in oracle...
can we implement execute using in postgresLeave a comment:
-
Execute statement in postgres
hi.. i know that to execute dynamic statements in postgres we have the EXECUTE statement..
but postgres support the execute using statement like in oracle... -
oh ok ok..thanks for all the help... it was really helpful.. thank u very muchLeave a comment:
-
ya ya... i change them.... is there a row count function in postgres and is there a writetoCLOB funciton in postgresLeave a comment:
-
i ll paste an orcale procedure here... i have to convert it into a postgres function...
CREATE OR REPLACE PROCEDURE ORCHCTADDDOCUME NT
(p_inxml IN OUT CLOB,
p_bravainfos OUT VARCHAR2,
p_duptitles OUT VARCHAR2,
p_outxml OUT CLOB,
p_outdocids OUT VARCHAR2
)
AS
will this...Leave a comment:
No activity results to display
Leave a comment: