Search found 45 matches

by piglet
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...
by piglet
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!
by piglet
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...
by piglet
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!
by piglet
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...
by piglet
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!
by piglet
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 = ...

Go to advanced search