1. Scott Roberts
  2. Valentina Database ADK
  3. Sonntag, Juli 01 2018, 06:22 PM
  4.  Abonnieren via E-Mail
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?
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort

CREATE TABLE t1( f1 STRING[3] DEFAULT ARRAY['abc','def','ghi'] )
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
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
Kommentar
There are no comments made yet.
  • Seite :
  • 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