1. Scott Roberts
  2. Valentina Database ADK
  3. Sunday, July 01 2018, 06:22 PM
  4.  Subscribe via email
Is it possible to set the default value for an array field? If so, what is the syntax for the DEFAULT clause in the CREATE TABLE statement?

Also, how would I enter the default value entered in Valentina Studio via the Object Editor. Do I need to use a method to set the default?
Comment
There are no comments made yet.
Ivan Smahin Accepted Answer

CREATE TABLE t1( f1 STRING[3] DEFAULT ARRAY['abc','def','ghi'] )
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Ruslan Zasukhin Accepted Answer
hi Scott,

when you asking about Valentina Studio, do you mean Create Table dialog?

In this dialog for a field on the right side exists properties panel.
It has DEFAULT VALUE field.

But sorry, we have found just only for ARRAY field it does not work correctly,
We will fix this for the next hotfix build 8.3.5
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories