Lines Matching refs:v

56     WITH data(k, v) AS (
59     UPDATE t1 SET z=v FROM data WHERE x=k;
71     CREATE TABLE t3(k, v);
73     INSERT INTO t3 VALUES(5,   'v');
80     UPDATE t1 SET y=v FROM t2, t3 WHERE t1.x=t2.a AND t3.k=t2.b;
85     1 i ten   2 xii two   3 v thirty   4 iv four
87     thirty->thirty   iii->v
92     WITH data(k, v) AS (
95     UPDATE t1 SET z=v FROM data WHERE x=k;
100     1 i eight   2 xii twelve   3 v thirty   4 iv four
114     WITH data(k, v) AS (
117     UPDATE v1 SET z=v FROM data WHERE x=k;
124     1 i eight   2 xii twelve   3 v fourteen   4 iv sixteen
125     thirty->thirteen  v->v
126     thirteen->fourteen  v->v
152     WITH data(k, v) AS (
155     UPDATE o1 SET z=v FROM data WHERE (1+x+w*2)=k;
167     UPDATE o1 SET y=v FROM t2, t3 WHERE (1+o1.w*2+o1.x)=t2.a AND t3.k=t2.b;
172     0 0 i ten   0 1 xii two   1 0 v thirty   1 1 iv four
174     thirty->thirty   iii->v
179     WITH data(k, v) AS (
182     UPDATE o1 SET z=v FROM data WHERE (1+w*2+x)=k;
187     0 0 i eight   0 1 xii twelve   1 0 v thirty   1 1 iv four
201     WITH data(k, v) AS (
204     UPDATE w1 SET z=v FROM data WHERE (1+w*2+x)=k;
211     0 0 i eight   0 1 xii twelve   1 0 v fourteen   1 1 iv sixteen
212     thirty->thirteen  v->v
213     thirteen->fourteen  v->v
269     CREATE TABLE x1(u, v, b, PRIMARY KEY(u, v)) %WO%;
276     UPDATE x1 SET b=y FROM data1 WHERE (u*2+v)=x ORDER BY u, v LIMIT 3;
284     UPDATE x1 SET b=b||y FROM data1 WHERE (u*2+v)=x ORDER BY b LIMIT 3;
315   WITH input(k, v) AS (
318   UPDATE t1 SET z=v FROM input WHERE x=k;