| From: | Eric B(dot)Ridge <ebr(at)tcdi(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | table functions |
| Date: | 2002-12-09 05:35:32 |
| Message-ID: | 088C7724-0B38-11D7-A9FB-0003930C70D8@tcdi.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
First, let me say that table functions are really cool!
Let's say I've defined a table function named: myTableFunc() (written
in C), and that I do this:
select a, b, c
from myTableFunc() as foo (a integer, b varchar(255), c text)
where a = 2;
Is it possible for me to get the FROM, WHERE, and AS ... clauses from
within my table function code? I'd like to do this so my table
function can be a little smarter about what it does and what it returns.
Also, in psql, if I press ^C while a table function is executing, the
function doesn't actually stop, but psql does say "Cancel request
sent". What processes this request? How do I tell postgres that I
want to be notified too?
thanks again!
eric
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pginfo | 2002-12-09 05:40:56 | Re: pg 7.3 memory error |
| Previous Message | Eric B.Ridge | 2002-12-09 05:04:55 | functions + shared libraries |