Is EXECUTE slower than a direct assignment call?
>-Original Message-
>From: Vibhor Kumar [mailto:vibhor.ku...@enterprisedb.com]
>Sent: 1 mars 2011 18:24
>To: Pierre Racine
>Cc: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Dynamic binding in plpgsql function
>
Hi,
I would like to write a generic plpgsql function with a text parameter being a
callback function name so that my general function can call this callback
function. e.g.:
CREATE OR REPLACE FUNCTION ST_MyCallbackFunction(y int)
RETURNS int AS $$
DECLARE
BEGIN
RETURN someCal
Hum right... Better follow Paul instructions. We are in geographic coordinates
here... Sorry. This would work in a limited projected space.
>-Original Message-
>From: pgsql-general-ow...@postgresql.org
>[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of
>Pierre Raci
Once PostGIS is installed you can do it with a single SQL query looking like
this:
SELECT dest.id, ST_Distance(ST_MakePoint(orig.longitude, orig.latitude),
ST_MakePoint(dest.longitude, dest.latitude))
FROM yourcitytable orig, yourcitytable dest
WHERE ST_DWithin(ST_MakePoint(orig.longitude, orig.
Hi,
Is there a way to tell PostgreSQL to keep only one instance of
postgres.exe running?
Thanks,
Pierre
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
I just hit twice the delete button on a function I spent two days writing
(without backing it up. I know... I know...). Is there a way to recover it?
A simple garbage would do the job. I don't know many software now that do
not implement a sort of simple mecanism to recover what we threw
