The Vertica Database Forums

usli06

This is typically done at the presentation layer; not the database layer.

Heh heh, I agree! But I'm trying to create some descriptive text to store in a table column, in that I want to store the degree symbol in the database column. The CHR(176) works perfect. Thanks!!!

usli06

Yeah, thanks Norbert! For some reason I thought I tried that function and observed rounding issues, so I was using the TRUNC function, like this: dbadmin=> SELECT FLOOR(4.56), TRUNC(4.56)::INT; FLOOR | TRUNC -------+------- 4 | 4 (1 row) The FLOOR function is obviously the better choice :)

usli06

How do I display the "degree" symbol in a vsql result set?

For example, like this for a temperature:

74°F

usli06

Hi,

Is there a function in Vertica like the INT function in Oracle?

Example INT(4.56) would be 4.

Thanks!

usli06

Good morning,

Sometime when I try to cancel a running query in vsql, I get the following message:

Could not send cancel request: PQcancel() -- connect() failed: No buffer space available

Note, the query does cancel, but what does this error mean?

usli06

Hi,

I cannot start a DB:

Code: Select all

[dbadmin@vertica ~]$ admintools -t start_db -d sales_db
Info: no password specified, using none
Unable to read database catalogs - cannot start database.
Database sales_db did not start successfully

Anyone know what the issue might be?

usli06

scutter, I got excited when I thought you were pointing me to a discussion about "General Hospital"

But after reading through the discussion on why I am seeing the unexpected result with NOT IN and NULL, now makes sense to me. Thanks for letting me know about link!

Search found 93 matches

Re: How to display the "degree" symbol?

Re: Is there an INT funtion in vertica?

How to display the "degree" symbol?

Is there an INT funtion in vertica?

Error: Could not send cancel request: PQcancel() -- connect() failed: No buffer space available

Unable to read database catalogs - cannot start database.

Re: How to handle NULL values and the NOT IN clause