Re: [GENERAL] Difference between CAST(v AS t) and v::t

2017-11-11 Thread Lele Gaifax
there is relevant documentation for this near CREATE INDEX; > it doesn't seem like the province of the typecast docs to explain > the weirdnesses of index syntax. Thank you Tom, I really missed the explanation in CREATE INDEX doc entry! ciao, lele. -- nickname: Lele Gaifax | Quando vivrò di qu

[GENERAL] Difference between CAST(v AS t) and v::t

2017-11-11 Thread Lele Gaifax
tic/sql-expressions.html#SQL-SYNTAX-TYPE-CASTS -- nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. l...@metapensiero.it | -- Fortunato Depero, 1929. -- Sent via pgsql-general mailing list (pgsql-g

[GENERAL] Registering aggregate function for a custom domain

2017-07-10 Thread Lele Gaifax
, registering a "compatible" array_agg() that accepts the domain too? Thanks in advance, ciao, lele. -- nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. l...@metapensiero.it | -- Fortunato Depe

Re: [GENERAL] Create recursive view schema.name

2016-10-11 Thread Lele Gaifax
d to me that I could use a not-qualified name within the view. bye, lele. -- nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. l...@metapensiero.it | -- Fortunato Depero, 1929. -- Sent via pgsql-ge

[GENERAL] Create recursive view schema.name

2016-10-11 Thread Lele Gaifax
IN sop.procedure_sites s ON s.site_id = ss.id ^ Am I missing something? Thanks in advance for any hint, ciao, lele. -- nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. l...@metapensiero.it |

Re: [GENERAL] Using function returning multiple values in a select

2015-10-24 Thread Lele Gaifax
ing. I hope this is clearer now, thank you, ciao, lele. -- nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. l...@metapensiero.it | -- Fortunato Depero, 1929. -- Sent via pgsql-general mailing

[GENERAL] Using function returning multiple values in a select

2015-10-24 Thread Lele Gaifax
ciao, lele. -- nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. l...@metapensiero.it | -- Fortunato Depero, 1929. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Understanding "seq scans"

2015-10-14 Thread Lele Gaifax
PG, I'm very glad to have at least a little opportunity to convince my coworkers to replace an awful MySQL subsystem with a shiny new implementation based on PostgreSQL! bye, lele. -- nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri real: Emanuele Gaifas | comincerò ad aver

Re: [GENERAL] Understanding "seq scans"

2015-10-13 Thread Lele Gaifax
n particular in the JSONB and HSTORE cases, where I didn't create an index on the field! Just for fun, I will try to learn about full text searches, another thing I never used on PG, and if it works against an HSTORE field... I don't know yet if I will need that machinery (current DB

Re: [GENERAL] Understanding "seq scans"

2015-10-13 Thread Lele Gaifax
you, ciao, lele. -- nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. l...@metapensiero.it | -- Fortunato Depero, 1929. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Understanding "seq scans"

2015-10-13 Thread Lele Gaifax
%word%'» in the context of a user session, and thus with a "preferred language". Thank you again, ciao, lele. -- nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. l...@metapensiero.it |

Re: [GENERAL] Understanding "seq scans"

2015-10-12 Thread Lele Gaifax
e: 4134.144 ms (19 rows) # select version(); version PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc

[GENERAL] Understanding "seq scans"

2015-10-12 Thread Lele Gaifax
row) Time: 3541.852 ms Why does the join on the master table require a "Seq Scan on master"? I tried different kinds of "JOIN", but the resulting explanation remains the same. Am I missing something, or should I stop worrying about that sequential scan? Thanks in advance