Re: foreach in sql functions
От | Tino Wildenhain |
---|---|
Тема | Re: foreach in sql functions |
Дата | |
Msg-id | 87652537.1033671471@liza обсуждение исходный текст |
Ответ на | foreach in sql functions ("Zac Hillier" <zac@affectors.net>) |
Список | pgsql-general |
Hi Zac, even better: INSERT INTO BskDtl (BskKey, PrdKey) SELECT $1,PrdKey FROM Prd WHERE Sts < 999; HTH Tino --On Mittwoch, 2. Oktober 2002 23:16 +0100 Zac Hillier <zac@affectors.net> wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
В списке pgsql-general по дате отправления: