Re: Posgres Adding braces at beginning and end of text (html) content

Поиск
Список
Период
Сортировка
От John Cheng
Тема Re: Posgres Adding braces at beginning and end of text (html) content
Дата
Msg-id 862298.59437.qm@web43415.mail.sp1.yahoo.com
обсуждение исходный текст
Ответ на Posgres Adding braces at beginning and end of text (html) content  (linnewbie <linnewbie@gmail.com>)
Список pgsql-general
Дерево обсуждения 
PostgreSQL does not add braces to text. It sounds like a problem with the code you have that inserts and retreives data
outof PostgreSQL 

Let's try a test case:

BEGIN;
CREATE TEMP TABLE test_table (
    foo text
);
INSERT INTO test_table (foo) VALUES('<html>foo</html>');
SELECT foo FROM test_table;
ROLLBACK;

The result of the select statement should look like:

       foo
------------------
<html>foo</html>
(1 row)

i.e., no added braces.

----
John L. Cheng




________________________________
From: linnewbie <linnewbie@gmail.com>
To: pgsql-general@postgresql.org
Sent: Thursday, April 2, 2009 5:48:40 AM
Subject: [GENERAL] Posgres Adding braces at beginning and end of text (html) content

Hi All,

I'm fairly new to postgres and I'm having this peculiar problem.

I'm storing raw html in a text field and I want users who know HTML to
update the content in a textarea field.

The problem is postgres is adding braces to the begining and ending of
the content.  On creation and every time I update.

This is:

I input:

<p>xyz <p/>
..........

into the text area field I save and view I see

{<p>xyz</p>

..........

}

On a subsequent update I see

{{<p>xyz</p>
.........

}}

On another I see

{{<p>xyz</p>

.....

}}

Not sure what is happening here?
I am using postgres 8.3 on windows

В списке pgsql-general по дате отправления: