On Tuesday 18 September 2007 17:15:43 Teodor Sigaev wrote:
> in 8.2
> SELECT headline('default', 'a b c', 'c'::tsquery,
> E'StartSel="", StopSel=""');
>
> >>> In 8.2 this produces an error:
> >>>
> >>> SELECT headline('default', 'a b c', 'c'::tsquery,
> >>> 'StartSel=, StopSel=');
> >>> ERROR: syn
in 8.2
SELECT headline('default', 'a b c', 'c'::tsquery,
E'StartSel="", StopSel=""');
In 8.2 this produces an error:
SELECT headline('default', 'a b c', 'c'::tsquery,
'StartSel=, StopSel=');
ERROR: syntax error
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
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=, StopSel=');
> > ERROR: syntax error
> > DETAIL: Syntax error in position 15.
>
> Sur
Andreas Joseph Krogh <[EMAIL PROTECTED]> writes:
> In 8.2 this produces an error:
> SELECT headline('default', 'a b c', 'c'::tsquery,
> 'StartSel=, StopSel=');
> ERROR: syntax error
> DETAIL: Syntax error in position 15.
Sure you don't just need to quote the values?
regression=# SELECT ts_head
Hi.
In 8.2 this produces an error:
SELECT headline('default', 'a b c', 'c'::tsquery,
'StartSel=, StopSel=');
ERROR: syntax error
DETAIL: Syntax error in position 15.
while this works:
SELECT headline('default', 'a b c', 'c'::tsquery,
'StartSel=, StopSel=');
headline
--
a b c
(1