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

Expand|Select|Wrap|Line Numbers

 
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

Quote:

Originally Posted by 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????

ravysters

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

rski

Quote:

Originally Posted by ravysters

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

Can postgres functions return multiple values???

re: Can postgres functions return multiple values???

re: Can postgres functions return multiple values???

re: Can postgres functions return multiple values???

re: Can postgres functions return multiple values???

re: Can postgres functions return multiple values???

re: Can postgres functions return multiple values???

re: Can postgres functions return multiple values???

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about