F18

sada ta funkcija prvo provjerava broj redova, pa pravi query

to se može uraditi u jednom query-ju:

f18_test=# SELECT version from fmk.semaphores_fakt_doks where user_code='test' UNION SELECT -1 ORDER BY version DESC LIMIT 1;

 version 
---------
      -1
(1 row)

f18_test=# SELECT version from fmk.semaphores_fakt_doks where user_code='test1' UNION SELECT -1 ORDER BY version DESC LIMIT 1;

 version 
---------
     348
(1 row)

ova funkcija se puno poziva, tako da asm siguran značajno utiče na performanse, posebno na slabijim konekcijama kao što je vpn

zabavan je ovaj SQL :)

f18_test=# SELECT version, last_trans_version from fmk.semaphores_fakt_doks where user_code='test1' UNION SELECT -1,-2 ORDER BY version DESC;

 version | last_trans_version 
---------+--------------------
     348 |                348
      -1 |                 -2