Can postgres functions return multiple values???

[ravysters]

hi.. i have a function which has 5 out parameters... can i return those in a postgre function...

[rski]

of course you can using OUT parameters. If you don't know how put you function/problem here and i'll try to help you.

[ravysters]

thank u so much.. i ll do that

[ravysters]

i ll paste an orcale procedure here... i have to convert it into a postgres function...


CREATE OR REPLACE PROCEDURE ORCHCTADDDOCUMENT
(p_inxml IN OUT CLOB,
p_bravainfos OUT VARCHAR2,
p_duptitles OUT VARCHAR2,
p_outxml OUT CLOB,
p_outdocids OUT VARCHAR2
)
AS





will this declaration work in postgresql????

[rski]

CREATE OR REPLACE PROCEDURE ORCHCTADDDOCUMENT
(IN OUT p_inxml CLOB,
OUT p_bravainfos VARCHAR2,
OUT p_duptitles VARCHAR2,
OUT p_outxml CLOB,
OUT p_outdocids VARCHAR2
)
AS
 

but you must change datatypes, there are no varchar2 and clob in postgresql

i ll paste an orcale procedure here... i have to convert it into a postgres function...


CREATE OR REPLACE PROCEDURE ORCHCTADDDOCUMENT
(p_inxml IN OUT CLOB,
p_bravainfos OUT VARCHAR2,
p_duptitles OUT VARCHAR2,
p_outxml OUT CLOB,
p_outdocids OUT VARCHAR2
)
AS





will this declaration work in postgresql????

[ravysters]

ya ya... i change them.... is there a row count function in postgres and is there a writetoCLOB funciton in postgres

[rski]

ya ya... i change them.... is there a row count function in postgres and is there a writetoCLOB funciton in postgres

To count rows you can use agregate function COUNT(*). There isn't CLOB type in Postgres so there is no writetoCLOB function. If I'm right you can implement CLOB with varchar.

[ravysters]

oh ok ok..thanks for all the help... it was really helpful.. thank u very much