| From: | Jefim Matskin <mjefim(at)sphera(dot)com> |
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | a simple programming question |
| Date: | 2001-09-06 11:21:25 |
| Message-ID: | 11EB6F74CACFD21199370050DAB8AA12A35F42@EXCHSPHERA |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)sphera(dot)com
http://www.sphera.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Kolve | 2001-09-06 12:01:41 | getting inherited table name |
| Previous Message | Peter Eisentraut | 2001-09-06 10:21:58 | Re: Bug in createlang? |