---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
I have the lat and long data. I have created the geom column based on the
lat and long data as below.
UPDATE property SET geom =GeometryFromText('POINT(' || long ||
' ' || lat || ')',4326);
Now I have the geom columns in two tables
I am calculating the distance as below
select distan
Hi
I have a latiude and longitude for a city and latitude, longitude foreach
hotel in hotels table.
I have to reitreive 20 hotels nearby to that city in 25 miles. The below is
the query I am using to check the distance. But the query is slow because of
distance calulation on fly and order b
Hi
The following query is working when this is used by static cursor. This will
return all the properties within the distance of 20 miles
v_point is a local variable. 'POINT(' || v_rec.lon || ' ' || v_rec.lat ||
')'
SELECT property_rating_id
, property_id
, property_name_fixed
This works. Thanks for response.
- Original Message -
From: "mark reid" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Friday, July 15, 2005 11:16 AM
Subject: Re: [GENERAL] Trigger on Update
Hi,
Change it to a "BEFORE UPDATE" trigger, and set NEW.updated_date := now();
Other
Can anybody help me creating a trigger on update
trigger with update statement as below.
This trigger fires after update on a table called
note to update the updated_date field.
But when the table is updated the trigger is firing
recursively.
Anybody know what is the syntax I have to
