X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id D7DB9D1B487
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 22 Dec 2003 10:54:47 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 95438-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 22 Dec 2003 06:54:01 -0400 (AST)
Received: from quality.qadas.com (quality.qadas.com [204.227.16.4])
	by svr1.postgresql.org (Postfix) with ESMTP id 956E3D1B4A3
	for <pgsql-sql@postgresql.org>; Mon, 22 Dec 2003 06:53:57 -0400 (AST)
Received: from quality.qadas.com (localhost [127.0.0.1])
	by quality.qadas.com (8.12.10/8.12.10) with ESMTP id hBMArsln001807;
	Mon, 22 Dec 2003 03:53:54 -0700 (MST)
Received: (from mfuhr@localhost)
	by quality.qadas.com (8.12.10/8.12.10/Submit) id hBMArr4G001805;
	Mon, 22 Dec 2003 03:53:53 -0700 (MST)
Date: Mon, 22 Dec 2003 03:53:53 -0700
From: Michael Fuhr <mfuhr+pgsql-sql@fuhr.org>
To: Daniel Lau <iedaniel@ust.hk>
Cc: pgsql-sql@postgresql.org
Subject: Re: Get x from point?
Message-ID: <20031222035353.A27167@quality.qadas.com>
References: <Pine.WNT.3.96L2.1031222164938.3432G-100000@iey118.ust.hk>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <Pine.WNT.3.96L2.1031222164938.3432G-100000@iey118.ust.hk>;
	from iedaniel@ust.hk on Mon, Dec 22, 2003 at 04:54:01PM +0800
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200312/143
X-Sequence-Number: 16309

On Mon, Dec 22, 2003 at 04:54:01PM +0800, Daniel Lau wrote:
> I am wondering if we are able to extract the x-coordinate from a
> point-type attribute with SQL. I have been looking for this sort of
> functions from documents and websites but it seems the function does not
> exist. Or, any altnernate to do so?