Re: [HACKERS] 8.3 version of ts_headline

2007-09-18 Thread Teodor Sigaev 

in 8.2
SELECT headline('default', 'a b c', 'c'::tsquery,
E'StartSel=span class=\\style1\\, StopSel=/span');


In 8.2 this produces an error:

SELECT headline('default', 'a b c', 'c'::tsquery,
'StartSel=span class=style1, StopSel=/span');
ERROR:  syntax error


--
Teodor Sigaev   E-mail: [EMAIL PROTECTED]
   WWW: http://www.sigaev.ru/

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [HACKERS] 8.3 version of ts_headline

2007-09-18 Thread Andreas Joseph Krogh 
On Tuesday 18 September 2007 17:15:43 Teodor Sigaev wrote:
 in 8.2
 SELECT headline('default', 'a b c', 'c'::tsquery,
 E'StartSel=span class=\\style1\\, StopSel=/span');

  In 8.2 this produces an error:
 
  SELECT headline('default', 'a b c', 'c'::tsquery,
  'StartSel=span class=style1, StopSel=/span');
  ERROR:  syntax error

Aha, thanks!

-- 
Andreas Joseph Krogh [EMAIL PROTECTED]
Senior Software Developer / Manager
+-+
OfficeNet AS| The most difficult thing in the world is to |
Karenslyst Allé 11  | know how to do a thing and to watch |
PO. Box 529 Skøyen  | somebody else doing it wrong, without   |
0214 Oslo   | comment.|
NORWAY  | |
Tlf:+47 24 15 38 90 | |
Fax:+47 24 15 38 91 | |
Mobile: +47 909  56 963 | |
+-+

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

Re: [HACKERS] 8.3 version of ts_headline

2007-09-15 Thread Andreas Joseph Krogh 
On Friday 14 September 2007 20:26:28 Tom Lane wrote:
 Andreas Joseph Krogh [EMAIL PROTECTED] writes:
  In 8.2 this produces an error:
 
  SELECT headline('default', 'a b c', 'c'::tsquery,
  'StartSel=span class=style1, StopSel=/span');
  ERROR:  syntax error
  DETAIL:  Syntax error in position 15.

 Sure you don't just need to quote the values?

 regression=# SELECT ts_headline('english', 'a b c', 'c'::tsquery,
 $$StartSel='span class=style1', StopSel='/span'$$);
 ts_headline
 ---
  a b span class=style1c/span
 (1 row)


   regards, tom lane

Doesn't work in 8.2:

andreak=# SELECT headline('default', 'a b c', 'c'::tsquery,
$$StartSel='span class=style1', StopSel='/span'$$);
ERROR:  syntax error
DETAIL:  Syntax error in position 16.
andreak=# select version();
version

 PostgreSQL 8.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 
(Ubuntu 4.1.2-0ubuntu4)
(1 row)


-- 
Andreas Joseph Krogh [EMAIL PROTECTED]
Senior Software Developer / Manager
+-+
OfficeNet AS| The most difficult thing in the world is to |
Karenslyst Allé 11  | know how to do a thing and to watch |
PO. Box 529 Skøyen  | somebody else doing it wrong, without   |
0214 Oslo   | comment.|
NORWAY  | |
Tlf:+47 24 15 38 90 | |
Fax:+47 24 15 38 91 | |
Mobile: +47 909  56 963 | |
+-+

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

Re: [HACKERS] 8.3 version of ts_headline

2007-09-14 Thread Tom Lane 
Andreas Joseph Krogh [EMAIL PROTECTED] writes:
 In 8.2 this produces an error:

 SELECT headline('default', 'a b c', 'c'::tsquery,
 'StartSel=span class=style1, StopSel=/span');
 ERROR:  syntax error
 DETAIL:  Syntax error in position 15.

Sure you don't just need to quote the values?

regression=# SELECT ts_headline('english', 'a b c', 'c'::tsquery,
$$StartSel='span class=style1', StopSel='/span'$$);
ts_headline
---
 a b span class=style1c/span
(1 row)


regards, tom lane

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate