Thanks guys!

Norbert - I knew about the sub - select option, but I was hoping to avoid that as I have a lot queries that need editing to do that.

Jim - I get it. We'll do better with our coding.

You guys are awesome

Hi all, Is it possible (like in MySQL) to reference a column alias in the same select statement in which it is defined? If not, is there a work around? dbadmin=> select x from test; x --- 1 2 3 2 2 (5 rows) dbadmin=> select x as a, a + 1 as b from test; ERROR 2624: Column "a" does not exist The abov...

Good morning,

Is it possible to limit a user to a single session log on? We would like to not have a user log on multiple times in different sessions.

Hello all,

When tuning queries in Oracle we use the ALTER SYSTEM FLUSH SHARED_POOL command to give a base line. This way queries won't benefit from any cached information.

Is there something similar in Vertica? Does Vertica even cache query results/explain plans?

Yes, that was it. Thanks a lot for your assistance!

Hi! I found that same solution on another site but I couldn't get it to run. I kept getting a weird message and just a list of the tables in my database: dbadmin=> SELECT regexp_substr(v_data1, `\d+`) FROM vd; unterminated quoted string List of tables Schema | Name | Kind | Owner | Comment ---------...

Good afternoon, Can someone please help me figure out a way that I can extract just the numbers from a text field? So if I have data like this: AAAAA92112BB ADFSA92113BB AAxAA921V 98122CVAAAA I would like to get these values in a query result set: 92112 92113 921 98122 Thanks in advance for any help...