Postgres Pro
Downloads
Home   >   mailing lists

Re: foreach in sql functions - Mailing list pgsql-general

From Tom Lane
Subject Re: foreach in sql functions
Date
Msg-id 29561.1033599482@sss.pgh.pa.us
Whole thread Raw
In response to foreach in sql functions  ("Zac Hillier" <zac@affectors.net>)
List pgsql-general
Tree view 
"Zac Hillier" <zac@affectors.net> writes:
> Is it possible to write sql functions with a foreach style loop?

SQL functions don't have any control structures.  Consider plpgsql,
pltcl, or plpython instead.

            regards, tom lane

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Anyone want to assist with the translation of the Advocacy site?
Next
From: John Worsley
Date:
Subject: [PATCH] PL/Perl (Mis-)Behavior with Runtime Error Reporting