Instinctively, I would think that plperl might be a little more wieldy than plpgsql for the required parsing, but I'm pretty sure a plpgsql solution could be created. Don't have one handy, though...
-tfo
-- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005
On Apr 12, 2005, at 12:51 PM, Mark Harrison wrote:
Suppose I'm adding row to a table, and one of the columns is a pathname.
I would like to generate in a separate table parent/child relationships based on the path.
For example, adding "/foo/bar/baz" and "/foo/bar/bot" would generate the following relationships
parent child ------ ----- /foo /foo/bar /foo/bar /foo/bar/baz /foo/bar /foo/bar/bot
Is this a reasonable thing to do in a trigger? Does anybody have a pl/sql snippet to do this?
Many TIA, Mark
-- Mark Harrison Pixar Animation Studios
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
