Hi all
I have problem with "convert" function. Previous behaviour was
SELECT convert('ján', 'UNICODE', 'SQL_ASCII');
===
jan
In postgresql 8.3 is quite new behaviour.
SELECT convert('ján', 'UNICODE', 'SQL_ASCII');
==
"j\241n
),'escape'),'latin2');
to_ascii
--
jan
(1 row)
Regards
Pavel Stehule
convert do conversion from text to bytea type. For diacritic
elimination use to_ascii function:
postgres=# select to_ascii(convert('Příliš žlutý kůň' using
utf8_to_iso_8859_2),'latin2&#x
Hi all
I have following problem when I use this
select headline('asd asd asd asd asd asd asd asd asd asd asd asd more more
more more more more more', to_tsquery('asd'), '');
I got this
"asd asd asd asd asd asd
asd asd asd asd asd asd more
more more"
So result is shorted than original
Thanks a lot. It helps.
On Fri, 04 Jan 2008 16:54:32 +0100, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
On Wed, 2 Jan 2008, Jan Sunavec wrote:
Hi all
I have following problem when I use this
select headline('asd asd asd asd asd asd asd asd asd asd asd asd more
more more more mor
"
Second problem is most important. On that line is first UTF8 character. I
read that it's necessary install patch tsearch_snowball_82.gz. But I am
running under windows and I am not so skill for windows compilation. I
thought that lastest PostgreSQL version has this patch included.
Thanks for help.
Jan Sunavec
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Hi
Is possible use SELECT NUM_ROWS, a, b, c FROM blabla WHERE x =id; I mean
it's much more faster than
SELECT a, b, c FROM blabla WHERE x =id; and then
SELECT count(*) FROM blabla WHERE x =id;
John
---(end of broadcast)---
TIP 6: Have you searc
ROTECTED]>
wrote:
On May 18, 2005, at 3:07 AM, Jan Sunavec wrote:
Hi
Is possible use SELECT NUM_ROWS, a, b, c FROM blabla WHERE x =id; I
mean it's much more faster than
SELECT a, b, c FROM blabla WHERE x =id; and then
SELECT count(*) FROM blabla WHERE x =id;
Can you do this on the cl
