X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id A9A03DA1B6
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 21 Nov 2005 17:48:22 -0400 (AST)
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 72378-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 21 Nov 2005 21:48:23 +0000 (GMT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 9BF83D975D
	for <pgsql-sql@postgresql.org>; Mon, 21 Nov 2005 17:48:18 -0400 (AST)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id A32B031059; Mon, 21 Nov 2005 22:48:18 +0100 (MET)
From: Rob <isanamespace@yahoo.com>
Subject: Storing HTML in table
X-Newsgroups: pgsql.sql
Date: Mon, 21 Nov 2005 16:47:51 -0500
User-Agent: KNode/0.9.2
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
Message-ID: <hq2dnTZ-cos83R_enZ2dnUVZ_tednZ2d@speakeasy.net>
Lines: 34
X-Complaints-To: abuse@speakeasy.net
X-DMCA-Complaints-To: abuse@speakeasy.net
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint
	properly
X-Postfilter: 1.3.32
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.928 required=5 tests=[FORGED_YAHOO_RCVD=0.928]
X-Spam-Score: 0.928
X-Spam-Level: 
X-Archive-Number: 200511/253
X-Sequence-Number: 23504

Hi:

I need to store markup in a database to control how the browser renders the
page information.

I would like complete control over this information -- so if sometime in the
future it's decided to totally redesign the layout. Also, at some point a
tool will be created so novice computer users can enter nicely formatted
markup -- meaning you won't have to know HTML to use this tool.

In it's raw form, data will be stored like this:

<p>some header goes here</p>
<p><img src='foo.gif'></p>
<p>more text here</p>

A few ideas are to:
 * Use css
        Store the data like: <span class='text_stuff'>text here</span>
        <span class='img_stuff'><img src=...></span>

 * Store in XML and XSLT

 * Don't use HTML -- but something that will parse keys into HTML. 
        E.G. [:bold] or [:img]

But what happens if you have a single item that's [:bold], <span
class="text-bold"> or etc. and need to take away the bold and change the
font size? It just seem that there is an easy way of doing this that I'm
not thinking of. 

Does anyone recommend a certain way for storing HTML in a table?

Thanks,