Re: [h2] Re: create domain text[]

2024-03-22 Thread 'Peter Borissow' via H2 Database
 Thanks for confirming that there is currently no way to create a "text[]" 
domain. 

Just as an aside, PostgreSQL has supported "text[]" and other arrays using 
"column_name datatype []" syntax since at least the 7.x release which is also 
more than 20 years old 
;-)https://www.postgresql.org/docs/7.1/arrays.htmlhttps://www.postgresql.org/support/versioning/
Thanks again for all your help. H2 is awesome!

Best,Peter

On Thursday, March 21, 2024 at 08:17:29 PM EDT, Evgenij Ryazanov 
 wrote:  
 
 Hello!

It isn't going to work, text[] is not an identifier and it cannot be used as 
domain name.

PostgreSQL supports standard arrays for more than 20 years, just use a standard 
definition in both PostgreSQL and H2.  

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/1736586456.179994.171871437%40mail.yahoo.com.


[h2] Re: create domain text[]

2024-03-21 Thread Evgenij Ryazanov
Hello!

It isn't going to work, text[] is not an identifier and it cannot be used 
as domain name.

PostgreSQL supports standard arrays for more than 20 years, just use a 
standard definition in both PostgreSQL and H2.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/b3c906ae-2836-4792-b1e3-fcf5266977d2n%40googlegroups.com.