Re: [SQL] UPDATE in a specific order

2010-12-17 Thread Luiz K. Matsumura
Thanks for reply, Em 16/12/2010 17:58, Jasen Betts escreveu: I need to make update of table1 with data on table2 in the order of id of table2 that looks like EAV. is it? Err, I don´t know so much about EAV, so I think that isn´t. I´m just trying to reproduce a calc in a spreeadsheet. Ther

Re: [SQL] Translate Function PL/pgSQL to SQL92

2010-12-17 Thread serviciotdf
Perfect! The query worked fine! Answer: ### CREATE OR REPLACE FUNCTION pruebas(varchar, varchar, integer) RETURNS void AS $delimiter$ INSERT INTO documentos(descripcion) SELECT $1 WHERE NOT EXISTS ( SELECT id FROM documentos WHERE descripcion = $1 ); INSERT INTO personal ( nombre, idtipodocumen

[SQL] Full Text search differences from 8.3 to 8.4.6

2010-12-17 Thread Achilleas Mantzios
Hello, i am currently evaluating the migration cost from 8.3 -> 9.x and in order to do that, i think i must have a confident view of the situation of my app with 8.4.6 as an intermediate stage. I noticed a few minor incompatibilities, but also a change in behaviour in full text search: