Search found 8 matches

by jane
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: 3059

Re: Referencing a column alias in the same select list

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 :D
by jane
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: 3059

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...
by jane
Fri Mar 14, 2014 11:15 am
Forum: New to Vertica Database Administration
Topic: Limit user to one session
Replies: 0
Views: 1083

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.
by jane
Sun Oct 27, 2013 4:33 pm
Forum: New to Vertica
Topic: Is there a Vertica Cache?
Replies: 2
Views: 2527

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?
by jane
Wed Aug 14, 2013 9:34 pm
Forum: Vertica SQL
Topic: Extract Just Numbers from String of Characters
Replies: 4
Views: 3443

Re: Extract Just Numbers from String of Characters

Yes, that was it. Thanks a lot for your assistance!
by jane
Wed Aug 14, 2013 8:32 pm
Forum: Vertica SQL
Topic: Extract Just Numbers from String of Characters
Replies: 4
Views: 3443

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 ---------...
by jane
Wed Aug 14, 2013 7:14 pm
Forum: Vertica SQL
Topic: Extract Just Numbers from String of Characters
Replies: 4
Views: 3443

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...

Go to advanced search