From: | Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com> |
---|---|
To: | Mark <Marek(dot)Balgar(at)seznam(dot)cz> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: track functions call |
Date: | 2011-05-11 19:42:01 |
Message-ID: | BANLkTikkA--R4vQjeU2sy=YCCu2dE0pmVg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2011/5/10 Mark <Marek(dot)Balgar(at)seznam(dot)cz>:
> Thanks for quick reply,
> but I want to know, which of these method is called in concrete situation. I
> suppose, that ts_rank call only one of these functions(ts_rank_wttf ,
> ts_rank_wtt , ts_rank_ttf ,ts_rank_tt ). Is it possible?
Yes, same table:
select proname,prosrc,prorettype,proargtypes from pg_proc where
proname = 'ts_rank';
proname | prosrc | prorettype | proargtypes
---------+--------------+------------+-------------------
ts_rank | ts_rank_wttf | 700 | 1021 3614 3615 23
ts_rank | ts_rank_wtt | 700 | 1021 3614 3615
ts_rank | ts_rank_ttf | 700 | 3614 3615 23
ts_rank | ts_rank_tt | 700 | 3614 3615
select oid,typname from pg_type where oid in ('1021','3614','3615','23','700');
oid | typname
------+----------
23 | int4
700 | float4
1021 | _float4
3614 | tsvector
3615 | tsquery
so you can find what go with what for the ts_rank function :
ts_rank([ weights float4[], ] vector tsvector,
query tsquery [, normalization integer ]) returns float4
> Thanks for reply
> Mark
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/track-functions-call-tp4384220p4385392.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Cédric Villemain 2ndQuadrant
http://2ndQuadrant.fr/ PostgreSQL : Expertise, Formation et Support
From | Date | Subject | |
---|---|---|---|
Next Message | salah jubeh | 2011-05-11 20:18:48 | Re: PGA |
Previous Message | Robert Haas | 2011-05-11 19:39:05 | Re: [GENERAL] postgresql-8.4 error -> BUG |