Calling Stored Procedures In Postgres

Dear visitor, welcome to QtForum.org. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

sunil_thaha

Intermediate

Posts: 484

Friday, December 10th 2004, 5:31am

Calling Stored Procedures In Postgres

Hi Guys

Can someone please tell me howto call the functions in Postgres.

Suppose there is a funtion call

fn_get_all_employees ( ) {
..........
...........
}

how do i Execute the function and get the Values.

Please Help

Check this 4m out http://QtCentre.Org - The Qt Community Centre

Go to the top of the page

djanubis

Professional

Posts: 1,370

Location: Moulins France

Occupation: Software ingeneering

Friday, December 10th 2004, 6:57am

RE: Calling Stored Procedures In Postgres

Exactly as other functions, ie

SELECT fn_get_all_employees ( ) FROM some_table

For more details read the stored procedures chapter of your PostgreSQL manual.

Never patch not working code. Rewrite it !
Never patch badly designed classes. Recreate them cleanly.
(Excerpts from Computing Bible)

Home of the Lab project

Go to the top of the page