[Q] The generality of extended function (in C)

From: "Seung-won Hwang" <shwang5(at)students(dot)uiuc(dot)edu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: [Q] The generality of extended function (in C)
Date: 2001-10-09 05:02:18
Message-ID: 01f001c1507f$92380ca0$0100a8c0@bluebird
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I'm curious about the extended function that one can write:

In plpgSQL, is it possble to use math functions? (pow,sqrt,sin,cos..)
Mine gives me the following errors. Is it because mine is outdated, or is it not supported?

template1=# select dist(61801,61802);
ERROR: Function 'pow(float8)' does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts

Suppose that one use C to address this problem, is it possble to look up DB in the code
as in plpgSQL? That is, does C have the counterpart to the below code in plpgSQL ?

SELECT INTO zip2_rec *
FROM zip
WHERE zip=zip2;
do something on zip_rec.lon

Thanks.

Browse pgsql-general by date

  From Date Subject
Next Message J C Lawrence 2001-10-09 05:07:31 Re:
Previous Message Zuev Dmitry 2001-10-09 04:37:10 Question about system catalog, documentation and datatype sizes (probably a bug)