The Vertica Database Forums

Hello All,

Is there a way we can say which function is a user_defined(created by user) function in user_functions table.

Currently I am seeing many functions in my user_functions system table

Example
ApproxCountDistinctLong

Also, I can see procedure type as Stored Procedure....are these nothing but External procedures.

Thanks

Hi!

[DELETED]

Thanks a lot skwa

I already knew that ApproxCountDistinct is not a user defined function, but was surprised to see it in user_functions table.

also, Does the same bug apply for stored Procedure thing

Thanks

Hi!

[DELETED]

Thanks skwa

The last part of your reply answered my doubt.

So there are three bugs

1. user_functions should have only user defined function, currently having all new function released with Vertica 7
2. procedure_type column should be function_type column description for this column in documents - The type of user defined function. For example, 'User Defined Function'.
3. user_function system table should not have stored procedures, currently showing EXT procedures also.

Thanks