| From: | Igor Shevchenko <igor(at)carcass(dot)ath(dot)cx> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | function callback |
| Date: | 2006-02-15 13:47:54 |
| Message-ID: | 200602151547.54793.igor@carcass.ath.cx |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi All,
Sorry if this was answered before, I was unable to find anything in archives.
Here's a problem I'm facing:
I have a "mimetype" table with all mimetypes my app has to deal with. I'm in a
process of adding a fulltext indexing (tsearch2) into my DB and I want to
specify a per-mimetype conversion function which would convert corresponding
data into a text suitable for indexing. PostgreSQL has a "regprocedure"
datatype (an alias to OID?) which can be added as a column to my "mimetype"
table but I can't find a way to execute a function by regprocedure from
pl/pgsql. Is there any way to do it except writing my own "C" function ? Or
maybe I'd better off adding a "text" field for function name and calling it
from pl/pgsql with EXECUTE "string" ?
--
Best Regards,
Igor Shevchenko
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2006-02-15 14:24:12 | Re: function callback |
| Previous Message | Carlos Henrique Reimer | 2006-02-15 12:44:36 | Date last vacuum |