Code: Select all
mykmeansPoly(x,3)
Code: Select all
mykmeansPoly(x,list('k'=3))
Search found 3 matches
- Mon Sep 28, 2015 1:15 am
- Forum: R Language Integration
- Topic: R TransformFunctions and Partition by
- Replies: 5
- Views: 29870
Re: R TransformFunctions and Partition by
I would think that this:
Should be more like this:
- Wed Mar 18, 2015 5:19 am
- Forum: Vertica SQL
- Topic: CAn you use a vsql variable in a where statement which expects a varchar
- Replies: 2
- Views: 6132
Re: CAn you use a vsql variable in a where statement which expects a varchar
Well a little more playing around and I got this to work:
sandbox=> \set MPcode to_char('LIPI3');
sandbox=> \echo :MPcode
to_char('LIPI3');
sandbox=> select MasterProductID from sandbox.DimProductMaster where MasterProductCode = :MPcode;
MasterProductID
-----------------
4867
(1 row)
sandbox=> \set MPcode to_char('LIPI3');
sandbox=> \echo :MPcode
to_char('LIPI3');
sandbox=> select MasterProductID from sandbox.DimProductMaster where MasterProductCode = :MPcode;
MasterProductID
-----------------
4867
(1 row)
- Wed Mar 18, 2015 4:53 am
- Forum: Vertica SQL
- Topic: CAn you use a vsql variable in a where statement which expects a varchar
- Replies: 2
- Views: 6132
CAn you use a vsql variable in a where statement which expects a varchar
Hi, I have defined a vsql variable: \set MPcode 'LIPI3'; now I would like to use it like so: select MasterProductID from sandbox.DimProductMaster where MasterProductCode = :MPcode; where MasterProductCode is a varchar but I get the error ERROR 2624: Column "LIPI3" does not exist How do I specify the...