phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Juvenn Woo <mach...@gmail.com>
Subject Re: Can set default value for column in phoenix ?
Date Fri, 14 Jul 2017 07:39:19 GMT
Hi Baitang,  

Yes, you can, but only constant value at the moment. So literal value such as ‘string’,
0, 0.0 would work well, but CURRENT_TIME will not. (As far as I know.)   

Best,
--  
Juvenn Woo
Sent with Sparrow (http://www.sparrowmailapp.com/?sig)


On Friday, 14 July 2017 at 3:29 PM, 曾柏棠 wrote:

> hi all,
>    Can set default value for column in phoenix ?
>    for example :
>  
> CREATE TABLE api.hahah(
> subscribe_time bigint not null  ,  
> hahha varchar default 'aaa',
> CONSTRAINT pk PRIMARY KEY (subscribe_time)
> )
>  
>  
> Thanks !
>  


Mime
View raw message