The Rel Forum

My mistake. This query, without the projection on GRP.RVA, will cause a fatal error:

The RANK operator is extremely useful especially when used with rva's (relation valued attributes). But in this context you have to be careful. For example, given this relation: REL{TUP{KEY. 1,ID "A"}, TUP{KEY. 2,ID "A"}, TUP{KEY. 3,ID "B"}, TUP{KEY. 4,ID "B"}, TUP{KEY. 5,ID "B"}} Suppose you want t...

Editing a rva is working in Rel versions 3.010 and 3.011.
It's not working in version 3.012 although it's possible to create an rva.

MATCHES is using a regex that looks for 2 strings, "40" and "GS". REL{TUP{ID 1,A "5A053"}, TUP{ID 2, A "64GS6"}, TUP{ID 3, A "YYYY"}, TUP{ID 4, A "X40F"}} WHERE MATCHES(A,"(.*40.*)*(.*GS.*)*") It should return a tuple where it finds either string. And it does, returning ID 2 and ID 4. RELATION {ID I...

This is a quote about the new SEARCH operator in Rel version 3.012: "new built-in operator SEARCH(t TUPLE{*}, regex CHAR) RETURNS BOOLEAN, which returns true if any CAST_AS_CHAR(a), where a is an attribute of t, matches regex." Your first inclination may be to assume that a is referring to scalar at...

I understand the need for a aggregate max operator but what I was really trying to get at was that duplicate values are not being recognized and eliminated. WRITELN REL{TUP{D Decimal(7.42,2)}, TUP{D Decimal(7.42,2)}, TUP{D Decimal(7.42,2)}} ; RESULT: RELATION {D Decimal} { TUPLE {D Decimal(7.42, 2)}...

The escape character is always decremented by 1 after saving a script in the database and then re-opening it.
Save WRITELN REPLACE_ALL("RANDOM()","ANDOM\\(\\)","") ;
Re-open the script and get:
WRITELN REPLACE_ALL("RANDOM()","ANDOM\(\)","") ;

VAR TESTD PRIVATE INIT( REL{TUP{ID 1,D Decimal(5.5,2)}, TUP{ID 2,D Decimal(7.0,0)}, TUP{ID 3,D Decimal(7.0,0)}, TUP{ID 4,D Decimal(7.0,0)}, TUP{ID 5,D Decimal(14.5,2)}, TUP{ID 6,D Decimal(23.5,2)}, TUP{ID 7,D Decimal(23.5,2)}, TUP{ID 8,D Decimal(35.5,2)}, TUP{ID 9,D Decimal(42.5,2)}} )KEY{ID}; //SA...

How stunningly obvious . How stunningly stupid I feel Nevertheless, thanks!

Hi, Any operator I try with the signature OPERATOR INTEGER(P CHARACTER) RETURNS INTEGER works outside of ALTER VAR. When ALTER VAR is used it always returns an error that the string is invalid: ERROR: RS0390: '"10"' isn't a valid number. Any chance you can spoon feed the appropriate operator and sho...

The following are two user defined type violations that can occur in an operator: ERROR: RS0037: Selector CHECK.FOR.MIXED.NUMERICAL.AND.NON.NUMERICAL.RANGES.WHICH.ARE.INVALID(BOOLEAN) violates POSSREP constraint in type 'FOR.IDS.MULTIPLIERS.AND.STRING.PART.NAMES..NUMERICAL.RANGES.WHERE.BEGINNING.AND...

Currently I would like new users to have the ability to open a relvar with multiple attributes with type character in Design view and change any of these character based attributes to either integer or rational (via ALTER VAR TYPE_OF) simply using point and click. Being able to change an integer bas...

I like ALTER especially as a handy point and click convenience. VAR T1 BASE REL{A CHAR, B INT, C RAT, D CHAR, E INT, F RAT}KEY{ }; T1:=REL{TUP{A "10", B 10, C 10.0, D "20", E 20, F 20.0}}; Changes from integer and rational respectively to character are successful. ALTER VAR T1 TYPE_OF B TO CHARACTER...

Sorry for the long delay in responding.
I should have been clear, I was referring specifically to anonymous operators.

This VAR declaration to access data in sql server 2016 worked as expected in Rel v3.004 but does not work with v3.010 or v3.011: VAR TEST4 EXTERNAL JDBC "jdbc:jtds:sqlserver://localhost:1433;databaseName=JUDYDB1,**,********,TEST1"; It returns the error: ERROR: Encountered "VAR" at line 12, column 1....