X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 38B09534F1 for ; Thu, 24 Mar 2005 01:34:08 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03788-08 for ; Thu, 24 Mar 2005 01:34:01 +0000 (GMT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id D200C534EB for ; Thu, 24 Mar 2005 01:33:59 +0000 (GMT) Received: (qmail 24703 invoked from network); 24 Mar 2005 01:34:04 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 24 Mar 2005 01:34:04 -0000 From: "Greg Sabino Mullane" To: pgsql-sql@postgresql.org Subject: Re: How do I do this? X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <4241A972.6040103@kencast.com> Date: Thu, 24 Mar 2005 01:34:03 -0000 X-Mailer: JoyMail 1.48 Message-ID: <8a3ceba57e3d59a95af0bd61a1057e44@biglumber.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.252 tagged_above=0 required=5 tests=AWL, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200503/321 X-Sequence-Number: 20800 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > I have a table with column filepath with contents that look like the following: .. > Is there anyway to retrieve the directory information only regarding those > filepaths? SELECT rtrim(substring(filepath from '.+/'),'/') FROM mytable; - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200503232033 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFCQhkMvJuQZxSWSsgRAjTaAJ9zmgSOBH/Nre/XMw+JajBni8YyDwCg1DyV Cd5rIhi026KFoFZEFjMOYvI= =V9ov -----END PGP SIGNATURE-----