PostgreSQL Function - are they like stored procedures?

[nicolasdiogo]

I have the following function on my PostgreSQL db.

CREATE OR REPLACE FUNCTION fctn_select_one()
RETURNS SETOF int4 AS
'select 1 as RETURN;'
LANGUAGE 'sql' VOLATILE;

My question is;

how do i connect a PHP page to my db, and extract the 'RETURN' value from my function 'fctn_select_one'?

Many thanks in advance.

i am certain that there are number of people out there with the same query.

Nicolas

[eoghain]

Just put it into a query like you would any other function.

SELECT fctn_select_one();