Options

What is the purpose of the AUDIT_LENGTH() function?

It seems that AUDIT_LENGTH() is run by an internal process. What's the purpose of this function and how does it differ from LENGTH()?
dbadmin=> CREATE TABLE test (name varchar(10));  CREATE TABLE  dbadmin=> INSERT INTO test (name) VALUES ('Tim');   OUTPUT  --------        1  (1 row)    dbadmin=> INSERT INTO test (name) VALUES ('Michael');   OUTPUT  --------        1  (1 row)    dbadmin=> COMMIT;  COMMIT    dbadmin=> SELECT AUDIT_LENGTH("name") FROM test;   AUDIT_LENGTH  --------------              3              7  (2 rows)    dbadmin=> SELECT LENGTH("name") FROM test;   LENGTH  --------        3        7  (2 rows)

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file