Search found 3 matches

by VaughanR
Mon Sep 28, 2015 1:15 am
Forum: R Language Integration
Topic: R TransformFunctions and Partition by
Replies: 5
Views: 12060

Re: R TransformFunctions and Partition by

I would think that this:

Code: Select all

mykmeansPoly(x,3)
Should be more like this:

Code: Select all

mykmeansPoly(x,list('k'=3))
by VaughanR
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: 1725

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)
by VaughanR
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: 1725

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

Go to advanced search