Hello,
From selected rows in a table, how can one extract and rank words/phrases based
on how often they occur?
Here's an example:
http://developer.yahoo.com/search/content/V1/termExtraction.html
INPUT:
CREATE TABLE phrases (
idBIGSERIAL,
phrase VARCHAR(1));
INSERT INTO phrases (phrase)
.
> Basically what we would like to do would be something like doing constraint
> validations only at the end of execution of an update query, instead of
> after every row update.
does it fail even if it's in a
BEGIN
UPDATE ..
COMMIT
?
--
Marius Andreiana
Galuna - Solu
mplete and tested push the modifications to the production
> session. To do that I'd need to be able to produce:
> 1. data-definition changes
http://sourceforge.net/projects/zongle
> 2. data added/modified to the tables
run the scripts to import/change data on both devel and productio
tgresql.org/docs/postgres/sql-checkpoint.html
http://developer.postgresql.org/docs/postgres/sql-savepoint.html
There are some examples in postgresql 7.5 new features announcements
over the net.
--
Marius Andreiana
Galuna - Solutii Linux in Romania
http://www.galuna.ro
---(
for sort_mem.
Thanks for the advice. I increased shmmax to allow shared_buffers to be
128mb and set sort_mem to 24mb.
--
Marius Andreiana
Galuna - Solutii Linux in Romania
http://www.galuna.ro
---(end of broadcast)---
TIP 6: Have you searched