Jack Orenstein writes:
> I guess the top-level question is this: Is it possible in principle for the
> btree index to subsume GIN index capabilities?
Well, you could write a completely different index AM that happened to
share the same on-disk representation, perhaps. But it would be a
different
I am working on a research project involving a datatype, D, with the
following characteristics:
- A value of D is a variable-length binary string.
- A value of D usually gives rise to a single index term, but there could
occasionally be more, (up to some configurable maximum).
- The index terms
Christophe Pettus writes:
> PostgreSQL doesn't have an exact equivalent. Typically, the OLD and NEW
> values are compared and then action is taken based on that. For example, in
> PL/pgSQL:
> IF NEW.is_canceled IS NOT DISTINCT FROM OLD.is_canceled THEN
> NEW.is_canceled := etc etc ;
> EN
> On Jan 1, 2021, at 07:56, Dirk Mika wrote:
> In particular, columns are populated with values if they are not specified in
> the update statement which is used.
> Usually with an expression like this:
>
> IF NOT UPDATING('IS_CANCELED')
> THEN
> :new.is_canceled := ...;
>
Hi all and a happy new Year!
We have an Oracle schema that is to be converted to PostgreSQL, where
conditional predicates are used in some triggers.
In particular, columns are populated with values if they are not specified in
the update statement which is used.
Usually with an expression like
Guten Tag Thomas Kellerer,
am Donnerstag, 31. Dezember 2020 um 21:31 schrieben Sie:
> ALTER INDEX pk_clt_rec_src RESET (fillfactor);
Thanks, should have looked into the docs instead of googling only! :-)
Mit freundlichen Grüßen,
Thorsten Schöning
--
Thorsten Schöning
AM-SoFT IT-Service - Bits
Hi Philip and Pavel,
Thank you for your contributions. Both seem very interesting :) I will look
into it
Happy New Year
Cheers
jmf
On Thu, Dec 31, 2020 at 3:25 PM Pavel Stehule
wrote:
>
>
> čt 31. 12. 2020 v 13:21 odesílatel Joao Miguel Ferreira <
> joao.miguel.c.ferre...@gmail.com> napsal:
>
