You are not logged in.

1

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

djanubis

Professional

  • "djanubis" is male

Posts: 1,370

Location: Moulins France

Occupation: Software ingeneering

  • Send private message

2

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