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
Search found 8 matches
- Thu Apr 07, 2016 4:51 pm
- Forum: New to Vertica SQL
- Topic: Referencing a column alias in the same select list
- Replies: 3
- Views: 23269
- Wed Apr 06, 2016 7:09 pm
- Forum: New to Vertica SQL
- Topic: Referencing a column alias in the same select list
- Replies: 3
- Views: 23269
Referencing a column alias in the same select list
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...
- Fri Mar 14, 2014 11:15 am
- Forum: New to Vertica Database Administration
- Topic: Limit user to one session
- Replies: 0
- Views: 4054
Limit user to one session
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.
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.
- Sun Oct 27, 2013 4:33 pm
- Forum: New to Vertica
- Topic: Is there a Vertica Cache?
- Replies: 2
- Views: 8530
Is there a Vertica Cache?
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?
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?
- Wed Aug 14, 2013 9:34 pm
- Forum: Vertica SQL
- Topic: Extract Just Numbers from String of Characters
- Replies: 4
- Views: 14111
Re: Extract Just Numbers from String of Characters
Yes, that was it. Thanks a lot for your assistance!
- Wed Aug 14, 2013 8:32 pm
- Forum: Vertica SQL
- Topic: Extract Just Numbers from String of Characters
- Replies: 4
- Views: 14111
Re: Extract Just Numbers from String of Characters
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 ---------...
- Wed Aug 14, 2013 7:14 pm
- Forum: Vertica SQL
- Topic: Extract Just Numbers from String of Characters
- Replies: 4
- Views: 14111
Extract Just Numbers from String of Characters
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...