Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 540D71337B68
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 25 Jan 2011 13:02:41 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 17656-07 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 25 Jan 2011 17:02:33 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-px0-f174.google.com (mail-px0-f174.google.com
	[209.85.212.174])
	by mail.postgresql.org (Postfix) with ESMTP id 8F9D1133655C
	for <pgsql-sql@postgresql.org>; Tue, 25 Jan 2011 13:02:33 -0400 (AST)
Received: by pxi15 with SMTP id 15so900696pxi.19
	for <pgsql-sql@postgresql.org>; Tue, 25 Jan 2011 09:02:32 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:message-id:date:from:to:cc:subject:references
	:mime-version:content-type:content-disposition:in-reply-to
	:user-agent; bh=yEH6yCUtygv9Rg18o++H65/j+8qMnTnsi3lgUCVNeoc=;
	b=qLieD2R0zR4bM4m/hA9MAzCwTUfi5u5ynfq7wXZ0X6+d52PrXBfM6zSGHtxuoYTWE4
	nThjDigM+vktuI0FVOKlOYqmTyi2y9B91UPJAOpYFKAbCH4vhlf9qbNwRL6cBvKe6zPV
	uLIfX0vEYygGjtG4v1BOEmo9mKFDNRwHhLtd0=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:cc:subject:references:mime-version
	:content-type:content-disposition:in-reply-to:user-agent;
	b=N920Xl6OrqDoXyVKn5d1foe/+JR1Vjwqhf6RD8ziH9LqRpymYvAf+Iosu5gdqwBLDr
	tnHmaowGDvE7mgNAD5Oqp3KHzxmgoOU8kJ7lS8Vj7cJVrut0o+jC1wxInTLQA8WWQTxi
	v+wrEVwXysr9IzFuI50C4DvAlVSwPztERABiQ=
Received: by 10.142.178.3 with SMTP id a3mr5468611wff.191.1295974952492;
	Tue, 25 Jan 2011 09:02:32 -0800 (PST)
Received: from eddie (c-67-186-249-122.hsd1.ut.comcast.net [67.186.249.122])
	by mx.google.com with ESMTPS id w14sm19071471wfd.18.2011.01.25.09.02.30
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Tue, 25 Jan 2011 09:02:30 -0800 (PST)
Message-ID: <4d3f0226.0e958e0a.1af4.628d@mx.google.com>
Date: Tue, 25 Jan 2011 10:02:02 -0700
From: Joshua Tolley <eggyknap@gmail.com>
To: gargdevender74 <gargdevender74@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: create geometry by lat/long
References: <1295953859755-3356073.post@n5.nabble.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="sHrvAb52M6C8blB9"
Content-Disposition: inline
In-Reply-To: <1295953859755-3356073.post@n5.nabble.com>
User-Agent: Mutt/1.5.18 (2008-05-17)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7
X-Spam-Level: 
X-Archive-Number: 201101/85
X-Sequence-Number: 35032


--sHrvAb52M6C8blB9
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Tue, Jan 25, 2011 at 03:10:59AM -0800, gargdevender74 wrote:
>=20
> how to create geometry (EPSG:4326) by lat/long. plz advice

Try ST_Point and ST_SetSRID()

http://www.postgis.org/docs/ST_Point.html

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

--sHrvAb52M6C8blB9
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAk0/AgoACgkQRiRfCGf1UMOuMgCeL8yLkb7PEHhH4yST9sqWmV8k
QH0AnRgVxfEo/2N0g1caGGac1KQWDsKf
=03iu
-----END PGP SIGNATURE-----

--sHrvAb52M6C8blB9--