Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

string fields helps


  • From: marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: string fields helps
  • Date: Mon, 16 Apr 2007 19:04:54 -0300 (ART)
  • Message-id: <94617(dot)80409(dot)qm(at)web32104(dot)mail(dot)mud(dot)yahoo(dot)com>

Folks  

  I need to save data on rtf format but , postgres   
refuses to storage for backslah or character's 
problem's   any idea or vice are welcomed       best
regards 
 mdc

pd: sample off data to save ( from postgres log)

"
 UPDATE plbrecord SET documentation =
'{\rtf1\ansi\deff0{\fonttbl{\f0\fnil Tahoma;}}
        \viewkind4\uc1\pard\lang1033\f0\fs16
        \par }
        ', version_ = 4 WHERE (plbrecord.id_ = 8 AND
plbrecord.version_ = 3 AND plbrecord.inst_class_ =
'EntityDataWindow')
LOG:  statement: COMMIT1
LOG:  statement: BEGIN
LOG:  statement: UPDATE plbrecord SET documentation =
'{\rtf1\ansi\deff0{\fonttbl{\f0\fnil Tahoma;}}
        \viewkind4\uc1\pard\lang1033\f0\fs16   SELECT
"PARAMETROS"."PARAMETRO",
        \par  
substr(to_char("PARAMETROS"."F_VAL_PARAM",
''YYYY/MM/DD''), 1,10),
        \par  
substr(to_char("PARAMETROS"."F_ANUL_PARAM",''YYYY/MM/DD''),
1,10),
        \par          "PARAMETROS"."VALOR1",
        \par          "PARAMETROS"."VALOR2"
        \par     FROM "PARAMETROS"
        \par " )
        \par
        \par }
        ', version_ = 5 WHERE (plbrecord.id_ = 8 AND
plbrecord.version_ = 4 AND plbrecord.inst_class_ =
'EntityDataWindow')
LOG:  statement: COMMIT
LOG:  statement: BEGIN
LOG:  statement: UPDATE plbrecord SET documentation =
'{\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0
Tahoma;}{\f1\fnil Tahoma;}}
        \viewkind4\uc1\pard\lang1033\f0\fs18   SELECT
"PARAMETROS"."PARAMETRO",
        \par  
substr(to_char("PARAMETROS"."F_VAL_PARAM",
''YYYY/MM/DD''), 1,10),
        \par  
substr(to_char("PARAMETROS"."F_ANUL_PARAM",''YYYY/MM/DD''),
1,10),
        \par          "PARAMETROS"."VALOR1",
        \par          "PARAMETROS"."VALOR2"
        \par     FROM "PARAMETROS"
        \par " )
        \par \f1\fs16
        \par }
"


      __________________________________________________ 
Preguntá. Respondé. Descubrí. 
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta). 
¡Probalo ya! 
http://www.yahoo.com.ar/respuestas 




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group