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
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;
INSERT INTO BskDtl (BskKey, PrdKey) VALUES ($1, Prd.PrdKey);
' LANGUAGE SQL
Any help or pointers very much appreciated.
pgsql-general by date
|Next:||From: Oleg Lebedev||Date: 2002-10-02 22:24:41|
|Subject: Re: foreach in sql functions|
|Previous:||From: Mark Wilson||Date: 2002-10-02 22:13:00|
|Subject: Re: database session variables |