Re: [GENERAL] need a query

-str ing-field-in-a-postgresql-group-by-query Mit freundlichen Grüßen Timo Klecker Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] Im Auftrag von AI Rumman Gesendet: Montag, 29. März 2010 10:45 An: pgsql-general General Betreff: [GENE

Re: [GENERAL] Need help on updating an entire column with a list of values, I have.

n code was not tested! Mit freundlichen Grüßen Timo Klecker Von: Rajan, Pavithra [mailto:raj...@coned.com] Gesendet: Freitag, 26. März 2010 15:17 An: Timo Klecker; pgsql-general@postgresql.org Betreff: RE: [GENERAL] Need help on updating an entire column with a list of valu

Re: [GENERAL] Need help on updating an entire column with a list of values, I have.

get tricky. Mit freundlichen Grüßen Timo Klecker Von: Rajan, Pavithra [mailto:raj...@coned.com] Gesendet: Freitag, 26. März 2010 15:17 An: Timo Klecker; pgsql-general@postgresql.org Betreff: RE: [GENERAL] Need help on updating an entire column with a list of values, I have. Hello

Re: [GENERAL] Need help on updating an entire column with a list of values, I have.

012 26528.0 057 29553.0 006 29872.0 009 30631.0 010 Mit freundlichen Grüßen Timo Klecker Von: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] Im Auftrag von Rajan, Pavithra

Re: [GENERAL] problems maintaining boolean columns in a large table

triggered on update? This would indeed slow everything down. As you mentioned you should move the needs_indexing flag out of the article table. This could simply hold all the article_ids that need indexing. Greetings Timo Klecker -Ursprüngliche Nachricht- Von: pgsql-general-ow

Re: [GENERAL] problems maintaining boolean columns in a large table

Hi Ben, could you post your trigger function? When you need to rebuild the index, you could disable the trigger setting the flag if the article is modified. This could speed up your UPDATE. Mit freundlichen Grüßen Timo Klecker -Ursprüngliche Nachricht- Von: pgsql-general-ow

Re: [GENERAL] Index on immutable function call

_table (cost=0.25..2450.96 rows=3 width=12) Index Cond: ((data1 > this_is_a_long_transformation(data2)) = true) Filter: (data1 > this_is_a_long_transformation(data2)) Greetings Timo Klecker -Ursprüngliche Nachricht- Von: pgsql-general-ow...@postgresql.org [mailto:pgsq

Re: [GENERAL] Need some advice on a difficult query

Hi Mike, here is an untested "weird nested query" for your problem: SELECT * FROM Recipes r where lower(RecipeTitle) like lower('%pasta%') and not exists (select 1 from ingredients inner join blacklist using (IngredientId) where RecipeId = r.RecipeId and blacklist.UserId = 123 limit 1);