lpad rpad function in derby

2011-03-28 Thread 蓦然回首
Hi All, I am using derby not long. I want to use lpad/rpad function like in oracle. I think there is one in derby but I can't find it. Is there this kind of functions in derby? Thanks a lot! Regards, jolt

Regarding databaseMetaData.getPrimaryKeys()

2011-03-28 Thread vipinsudhakar
Dear All, The procedure databaseMetaData.getPrimaryKeys() returns the same primary key for the same table twice. Is that possible to have a duplicate primary key in a table? for ex; Table Name:EMP PrimaryKey:EMPID Table Name:EMP PrimaryKey:EMPID It returns something like this from one of our clie

Re: Add current_timestamp default to existing timestamp column

2011-03-28 Thread Knut Anders Hatlen
Peter Robbins writes: > To whom it may concern, > > Although mentioned in the documentation, doesn't appear to work? > > Could you please give me correct syntax for this? Or add this to the Jira > items? Hi Peter, This seems to work: ij> create table t(ts timestamp); 0 rows inserted/updated/d