Search found 45 matches
- Thu Sep 12, 2013 12:35 pm
- Forum: New to Vertica SQL
- Topic: Return a range of dates between 2 given dates
- Replies: 7
- Views: 22282
Re: Return a range of dates between 2 given dates
Thanks, sKwa, but I am looking to get just the dates that fall in between two other dates. For instance, if I use 09/02/2013 and 09/13/2013, I'd like to only get the results: 09/02/2013 09/03/2013 09/04/2013 09/05/2013 09/06/2013 09/07/2013 09/08/2013 09/09/2013 09/10/2013 09/11/2013 09/12/2013 09/1...
- Wed Sep 11, 2013 7:23 pm
- Forum: New to Vertica SQL
- Topic: Return a range of dates between 2 given dates
- Replies: 7
- Views: 22282
Return a range of dates between 2 given dates
Hi,
I have one more I would like a query that returns the range of dates that fall in between two dates?
Thanks, again!
I have one more I would like a query that returns the range of dates that fall in between two dates?
Thanks, again!
- Wed Sep 11, 2013 7:17 pm
- Forum: New to Vertica SQL
- Topic: Do not update null values in table with merge
- Replies: 2
- Views: 6628
Do not update null values in table with merge
Howdy, I need to write a merge statement for a table column where the source could be null. If it is null, I don't want that column updated but I want the rest of the columns updated. Is there an option of the merge command that I can use to selectively update a column? If you need more info. please...
- Fri Apr 26, 2013 3:31 am
- Forum: Vertica SQL
- Topic: Generate Fibonacci Series in SQL
- Replies: 2
- Views: 5818
Re: Generate Fibonacci Series in SQL
Wow, thanks!!! You are one brilliant dude, skwa!
- Thu Apr 25, 2013 4:12 pm
- Forum: Vertica SQL
- Topic: Generate Fibonacci Series in SQL
- Replies: 2
- Views: 5818
Generate Fibonacci Series in SQL
Hello all! Can someone help me write a SQL statement to generate the Fibonacci series of numbers? I found this solution in Oracle, but it won't work in Vertica :( WITH fb(k1, k2) AS ( SELECT 0 k1, 1 k2 FROM dual UNION ALL SELECT k2 AS k1, k1 + k2 AS k2 FROM fb WHERE greatest(k1, k2) < 100 ) SELECT k...
- Fri Apr 05, 2013 3:58 pm
- Forum: Vertica Performance Tuning
- Topic: Slow Inserts
- Replies: 7
- Views: 20449
Re: Slow Inserts
Use the INSERT command!
- Fri Apr 05, 2013 3:56 pm
- Forum: New to Vertica Database Administration
- Topic: Row Size System Limit
- Replies: 1
- Views: 4136
Row Size System Limit
Hello, I was reading over the SQL Reference Manual and noticed that there is a hard limit of 32 MB of data for a table row while we can have up to 1600 columns per table. Does that 32 MB limit the number or columns? That is can we only have 516 VARCHAR(65000) columns? 516 * 65000 = 33540000 bytes = ...