[BUGS] ST_Distance Issue

2011-11-17 Thread Archana Sachin Ghag
139,27.59765625 55.3541353102106,36.38671875 48.3124279040718,22.32421875 40.3465441211801,5.888671875 43.8662180065564,-0.791015625 48.4874864798841)', 900913) ) Query returns 122.785055218779 What is significance of SRID here. Am I missing something? Which SRID should we use for general purpose.

[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"."

[BUGS] BUG #2601: postgres not running

2006-08-31 Thread archana
The following bug has been logged online: Bug reference: 2601 Logged by: archana Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: fedora core 4 Description:postgres not running Details: installed postgres as root user by gmake but now