| From: | miko(at)idocs(dot)com (Miko O'Sullivan) |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [BUGS] session variable |
| Date: | 2003-09-13 18:23:36 |
| Message-ID: | db27ea77.0309131023.4b94ae6@posting.google.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-sql |
pgman(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian) wrote in message news:<200309032042(dot)h83KgmJ24665(at)candle(dot)pha(dot)pa(dot)us>...
> Yes, see the FAQ. You have to use EXECUTE for temp table access in
> functions.
Unfortunately in the 7.2.x version I have available, EXECUTE does not
allow "select into". The docs suggests a technique for using a FOR
loop to extract information from an EXECUTE, but the technique only
works for finite set of expected variables, not for arbitrary values.
Any suggestions on how to kludge this issue? It would be of great
value to me if there were a way to set and retrieve just one global
variable that persists throughout a session, and which can be
retrieved from a function.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-09-13 22:51:23 | Re: 7.3.2 incorrectly counts characters for unicode varchar field |
| Previous Message | Matthew Cooper | 2003-09-12 19:43:41 | 7.3.2 incorrectly counts characters for unicode varchar field |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manfred Koizar | 2003-09-13 18:52:02 | Re: Q: select query |
| Previous Message | Rod Taylor | 2003-09-13 18:17:16 | Re: Q: select query |