Hi All,
I have only recently started using pgsql and would like to try some internal
functions as it appears this would be quicker than running similar functions
from php.
Is it possible to write sql functions with a foreach style loop?
CREATE FUNCTION crt_bsk_dtl(integer) RETURNS integer AS '
SELECT PrdKey FROM Prd WHERE Sts < 999;
foreach(Prd.PrdKey){
INSERT INTO BskDtl (BskKey, PrdKey) VALUES ($1, Prd.PrdKey);
}
SELECT 1;
' LANGUAGE SQL
Any help or pointers very much appreciated.
Thanks
Zac