| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Van Ingen, Lane" <lvaningen(at)ESNCC(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: First plpgsql Script |
| Date: | 2005-05-11 14:05:02 |
| Message-ID: | 3610.1115820302@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
"Van Ingen, Lane" <lvaningen(at)ESNCC(dot)com> writes:
> The only plpgsql commands available that I am aware of are assignment commands, loop-related commands, logical tests (if-then-else), and the like. Perhaps I was hoping that plpgsql has more capability than it does. What I was specifically looking for is to be able to do things like date arithmetic, manipulate stored arrays, accumulate totals, etc. against stored variables while assigning the result to yet another stored variable.
You seem to be supposing that assignment is incapable of doing any
computation :-(.
You might try looking at the examples that show how to duplicate
Oracle's instr() functions:
http://www.postgresql.org/docs/8.0/static/plpgsql-porting.html#PLPGSQL-PORTING-APPENDIX
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikola Milutinovic | 2005-05-12 05:34:42 | Using PgSQL in high volume and throughput problem |
| Previous Message | Geoffrey | 2005-05-11 13:59:15 | Re: Select dump |