Comments for select * from depesz;

Comment on Waiting for 8.5 – let’s start by gregj

gregj — Fri, 03 Jul 2009 22:37:54 +0000

they commited new feature in xml Today
I bet you haven’t wrote anything about xml support in postgresql at all yet

Comment on explain.depesz.com – update by Marcin

Marcin — Fri, 19 Jun 2009 07:13:58 +0000

Coś rzeczywiście spamuje, nie znalazłem niczego w źródle, ani w źródle kanału… ciekawostka

http://iworks.pl/wp-content/uploads/2009/06/image_036.png

Comment on explain.depesz.com – update by GiM

GiM — Wed, 17 Jun 2009 19:48:14 +0000

Take a look at the source I see it starting just after div id=”page” class=”clearfix”
(feel free to remove those comments, as they doesn’t have much to do with posts itself)

Comment on explain.depesz.com – update by depesz

depesz — Wed, 17 Jun 2009 19:27:48 +0000

I heard about this already, but there is no such spam on blog. I think it’s an issue with feedburner. I will turn it off, but not in the next 2 weeks.

Comment on explain.depesz.com – update by GiM

GiM — Wed, 17 Jun 2009 19:25:38 +0000

Sorry for the OT, bbut your blog is somehow spammed (I assume you didn’t do that), take a look at the source of the page. I’ve noticed that while viewing in rss reader.

Comment on “FATAL: Ident authentication failed”, or how cool ideas get bad usage schemas by Vitor Isaia

Vitor Isaia — Tue, 09 Jun 2009 14:33:33 +0000

Thanks a lot, GREAT tutorial.

Comment on drzewa w sql’u – metoda pełnych ścieżek (metoda nr. 5 w/g starego tekstu) by depesz

depesz — Fri, 22 May 2009 18:16:46 +0000

@trawka
http://www.depesz.com/index.php/2008/04/11/my-take-on-trees-in-sql/

Comment on Polish TSearch in 8.3 (polski tsearch w postgresie 8.3) by tm

tm — Fri, 22 May 2009 18:13:53 +0000

Po utworzeniu słowników wg tej recepty robię test i dostaję taki błąd?

text search configuration “public.polish” does not exist

Dodam, że \dF pokazuje mi w konfiguracji “public.polish”, a \dFd “public.polish_ispell”.

Comment on drzewa w sql’u – metoda pełnych ścieżek (metoda nr. 5 w/g starego tekstu) by trawka

trawka — Fri, 22 May 2009 16:47:19 +0000

tak, tylko jak uzyskac odpowienio posortowany wynik z bazy?

Comment on tsearch i synonimy by depesz

depesz — Wed, 20 May 2009 12:23:58 +0000

planetpostgresql.org miał wielką awarię w zeszłym roku, z utratą danych włącznie. można spróbować poszukać na web archive, ale nie wiem czy tam jest,

Comment on tsearch i synonimy by Adam

Adam — Wed, 20 May 2009 12:19:47 +0000

Szkoda, że link już nie jest aktywny

Comment on Waiting for 8.4 – CASE in pl/PgSQL by lotso

lotso — Sun, 10 May 2009 08:59:33 +0000

I’m honestly surprised that it’s not already in.

Comment on choroby by Clippo

Clippo — Fri, 08 May 2009 10:53:36 +0000

Ostatnio moja mama postanowiła zrobić badania na borelioze. Wynik wyszedł pozytywny i przez miesiąc leżała w szpitalu. Opuchlizna częściowo zeszła i bóle pleców jak rownież ogolne osłabienie prawie minęło więc osobom mającym podobne objawy polecam przebadanie się. Lekarze niestety wogole tego nie podejrzewają i nawet nie chcą dać skierowania niestety, więc trzeba to załatwiać na własną rękę.

Comment on Waiting for 8.4 – Common Table Expressions (WITH queries) by VLDG

VLDG — Wed, 29 Apr 2009 22:14:34 +0000

I confirm : CTE is great enhancement.
I use it in Firebird 2.1 and it works very well.

Comment on Waiting for 8.4 – timing on/off by Adeline Boronat

Adeline Boronat — Mon, 27 Apr 2009 21:26:42 +0000

good goodthis post deserves nothing hahaha just joking nice post

Comment on perl best practices critic by Irvin Almquist

Irvin Almquist — Mon, 27 Apr 2009 08:38:52 +0000

You are a very smart person!

Comment on “ERROR: operator does not exist: integer = text” how to fix it? by depesz

depesz — Mon, 27 Apr 2009 08:29:31 +0000

@flexpadawan:
well, one could argue that it should work, but generally – don’t mix your datatypes.

change your array to be text[] and not varchar[], and it will work.

Comment on “ERROR: operator does not exist: integer = text” how to fix it? by flexpadawan

flexpadawan — Mon, 27 Apr 2009 05:11:32 +0000

I’m trying to get my EXECUTE function to work and is giving me type cast errors and has me stumped. And I’m not sure how to align the casting properly.

I have a trigger that calls a function. In my trigger I dynamically create my select statement.

My Variable:
array_details character varying[];
I populate it with {a,b}

Hard-coded (Works):
SELECT catalogue.cg_bdd (ARRAY['a','b']);

Dynamically Created (Fails):
EXECUTE ‘SELECT catalogue.cg_bdd ‘(’ || array_details || ‘);’;

Error:
ERROR: operator does not exist: text || character varying[]
LINE 1: SELECT ‘SELECT ‘ || $1 || ‘(’ || $2 || ‘);’
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
QUERY: SELECT ‘SELECT ‘ || $1 || ‘(’ || $2 || ‘);’

Comment on Set operations in shell by smk

smk — Thu, 23 Apr 2009 08:03:46 +0000

http://linux.die.net/man/1/combine

Comment on Removing elements from arrays by flexpadawan

flexpadawan — Wed, 22 Apr 2009 04:56:26 +0000

Great Post! Been trying to figure out how to do this for the last 3 days!

I did some testing and tweaking.

The Test on postgres 8.3:
306.370ms – plpgsql (Winner) AMD Quad-Core??
1849.881ms – sql

The Tweek:
I re-wrote this to allow for any data type.

CREATE OR REPLACE FUNCTION array_difference(anyarray, anyarray)
RETURNS anyarray AS
$BODY$
declare
out_arr $1%TYPE;
el_idx int;
begin
if $1 is null or $2 is null then
return $1;
end if;
for el_idx in array_lower($1, 1)..array_upper($1, 1) loop
if not $1[el_idx] =any($2) then
out_arr = array_append(out_arr, $1[el_idx]);
end if;
end loop;
return out_arr;
end;
$BODY$
LANGUAGE ‘plpgsql’ IMMUTABLE
COST 100;
ALTER FUNCTION array_difference(anyarray, anyarray) OWNER TO postgres;

Comment on ed2k checksumming by depesz

depesz — Mon, 20 Apr 2009 22:00:42 +0000

@val:
i’m not aware of any special treatment for cases where size = X * 9728000. and as for < 9728000 – check comment #04 and my reply in #05.

Comment on ed2k checksumming by val

val — Mon, 20 Apr 2009 20:28:34 +0000

You missed cases:
when size is less than 9 728 000 bytes
when size is X * 9 728 000 bytes

For them you’ll get wrong hash.

Comment on Learning POE: HTTP-2-MUD proxy by James

James — Fri, 10 Apr 2009 19:31:18 +0000

Coro/AnyEvent are way superior in terms of usability and performance. They just lack the numbers of dependent modules POE has, though with Coro::Select you can use many modules that use blocking selects, which you can’t with POE.

Comment on Getting list of all children in “adjacency list” tree structure by Bastiaan

Bastiaan — Tue, 07 Apr 2009 19:51:42 +0000

for gregj:

WITH RECURSIVE struct AS (
SELECT t.* FROM test t WHERE parent_id = 1
UNION ALL
SELECT t.* FROM test t, struct s WHERE s.id = t.parent_id
)
SELECT ARRAY(SELECT id FROM struct) AS ID;

Comment on How to find newest file with given name? by Nexon

Nexon — Mon, 06 Apr 2009 23:42:31 +0000

I just wanted to say that I love this site

Comment on Waiting for 8.4 – database-level lc_collation and lc_ctype by Troy

Troy — Wed, 01 Apr 2009 03:06:02 +0000

I used pg_collkey to get around collation order in 8.1.x, however since we are using 8.3 now this does not work anymore.

ORDER BY collkey(field,locale) ;

is there any other way currently in 8.3 or 8.4 i can achieve this?

Comment on tsearch – instalacja, testy, rozszerzanie by depesz

depesz — Mon, 30 Mar 2009 18:08:47 +0000

@kamil:
tak, ale musisz dodać tabelę ze słowami z tsearcha, na niej używać trgm’a. i po prostu zamiast szukać jednego słowa w tsearchu, to szukać alternatywy słów znalezionych przez trgm.

Comment on What does “success” mean to You? by Mario

Mario — Sun, 29 Mar 2009 22:55:58 +0000

I wake up in the morning.
I go to bed in the evening.
In between I do what I want.
I think I’m pretty successful.

Comment on tsearch – instalacja, testy, rozszerzanie by kamil

kamil — Sun, 29 Mar 2009 14:51:42 +0000

@depesz
czy da się w jakiś sensowny sposób połączyć trgm z tsearch2, chodzi o to aby tsearch szukał również na podstawie błędnie podanego wyrazu ?

Comment on Getting list of all children in “adjacency list” tree structure by Robert Young

Robert Young — Tue, 24 Mar 2009 13:46:25 +0000

I am waiting for 8.4 and Common Table Expressions. I’ve used them in SQLServer for a while, and DB2 for years. A Much, much more logical way to answer the question. Let’s go 8.4