FW: a plpgsql programming question
| От | Jefim Matskin |
|---|---|
| Тема | FW: a plpgsql programming question |
| Дата | |
| Msg-id | 11EB6F74CACFD21199370050DAB8AA12A35F47@EXCHSPHERA обсуждение исходный текст |
| Список | pgsql-general |
I have the following problem; The client of the DB issues a lot of the SQL commands over a network , the statements are of the simple form - select an integer from some table(s) using some criteria. I want to create a function that will accept the string containing all the statements to be executed, a string containing the length of the statements to be executed and will return the string containing all the integer values retrieved. And the questions are: 1. How to execute a sql statement that is contained in the text variable in the function 2. How to get the result of that statement into a variable. Thanks. Jefim Matskin --------------------------------------------- Senior SW engeneer Sphera Corporation Tel: +972.3.613.2424 Ext:104 mailto:mjefim@sphera.com http://www.sphera.com/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
В списке pgsql-general по дате отправления: