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.
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) |