display data type of an expression?

[dbmsuser7]

Is there any function for displaying the data type of an expression?

[NorbertKrupa]

Do you have an example? I'm not sure what you mean by expression (column, function, etc.)

[dbmsuser7]

E.g.

Code: Select all

165323*(123456.7890123::NUMERIC(13,7))

the only way I can see to figure out whether this is a NUMERIC or a FLOAT is to create a table by putting this into a

Code: Select all

CREATE TABLE ... AS SELECT

statement, then do

Code: Select all

\d [i]table_name[/i]

Would be much easier to type

Code: Select all

SHOW_TYPE(165323*(123456.7890123::NUMERIC(13,7)))

if such a function existed.

[NorbertKrupa]

Ah. I know SQL Server has the SQL_VARIANT_PROPERTY, but I'm unaware of one for Vertica. It would definitely be a nice function to have.

[dbmsuser7]

Thanks.

[id10t]

Hi!

[DELETED]

[dbmsuser7]

And how about function overloading?

Yeah, that seems like a handy trick. I'll try that soon.