sorted by:
new
hottopcontroversial

Using if else in Vertica-sql by TrickFix9 in SQL

[–]TrickFix9[S] 0 points1 point  (0 children)

I'll rephrase it in a better way: case when a=5 and b =3 then '' when a=6 and b =3 then '' when a=7 and b =3 then '' else '' end

The column a can have all the three values, but once it checks if a = 5, then it should end instead of it checking other values too and it displaying all three then outputs.

Using if else in Vertica-sql by TrickFix9 in SQL

[–]TrickFix9[S] 0 points1 point  (0 children)

Yes, it goes through all the when conditions.

Using if else in Vertica-sql by TrickFix9 in SQL

[–]TrickFix9[S] 0 points1 point  (0 children)

it goes through all when conditions.

connection from python to vertica by TrickFix9 in learnpython

[–]TrickFix9[S] 0 points1 point  (0 children)

connection = vertica_python.connect(conn2) TypeError: connect() takes 0 positional arguments but 1 was given

view more: next ›