phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "M. Aaron Bossert" <maboss...@gmail.com>
Subject perhaps dumb question? workaround for default values
Date Thu, 10 Sep 2015 19:40:24 GMT
I have a table that requires an additional column with the current date
added.  I realize that I can't do this using the CSV importer...How can I
do that in a query?  I tried standard SQL with UPSERT instead of INSERT:

UPSERT INTO NG.BARS_CNC_DETAILS_HIST SET PULL_DATE=CURRENT_DATE();


but this gives a syntax error.

Mime
View raw message