table functions

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: Raw Message | Whole Thread | 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

In response to

Responses

Browse pgsql-general by date

  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