[BUGS] ST_Distance Issue

2011-11-17 Thread Archana Sachin Ghag
I am calculating distance from my current location with all available regions(polygons) in my table. I am using ST_Distance method for this. My regions are stored with SRID = 900913. Distance for point in Europe from USA region is coming as 122.78. How come this possible. These regions are so far

[BUGS] Issue with passing NULL for function parameter

2011-11-03 Thread Archana Sachin Ghag
I have wriiten following simple function in postgresql CREATE OR REPLACE FUNCTION "MySchema".add_user(p_name character varying, p_email1 character varying, p_email2 character varying) RETURNS bigint AS $BODY$ DECLARE userId bigint; BEGIN INSERT INTO "MySchema"."