The C++11 approach is: struct Testable { explicit operator bool() const { return false; } }; int main () { Testable a, b; if (a) { /* do something */ } // this is correct if (a == b) { /* do something */ } // compiler error } Note the explicit keyword which prevents … Read more
Even though you can not return the UDTT from a function, you can return a table variable and receive it in a UDTT as long as the schema match. The following code is tested in SQL Server 2008 R2 — Create the UDTT CREATE TYPE dbo.MyCustomUDDT AS TABLE ( FieldOne varchar (512), FieldTwo varchar(1024) ) … Read more
Simply setting the __hash__ method to that of the tuple class is not enough. You haven’t actually told it how to hash any differently. tuples are hashable because they are immutable. If you really wanted to make you specific example work, it might be like this: class X2(list): def __hash__(self): return hash(tuple(self)) In this case … Read more
As of my knowledge it is impossible to alter/modify a table type.You can create the type with a different name and then drop the old type and modify it to the new name Credits to jkrajes As per msdn, it is like ‘The user-defined table type definition cannot be modified after it is created’.
I really hope you’ve solved this by now, seeing as the question is almost 4 months old, but in case you haven’t, here’s what I think is the answer. GRANT EXEC ON TYPE::[schema].[typename] TO [User] GO
I add here the complete solution for creating types in a simple script, without the need of creating a function just for this purpose. –create types DO $$ BEGIN IF NOT EXISTS (SELECT 1 FROM pg_type WHERE typname=”my_type”) THEN CREATE TYPE my_type AS ( –my fields here… ); END IF; –more types here… END$$;
The former is correct, if arg accepts an instance of CustomClass: def FuncA(arg: CustomClass): # ^ instance of CustomClass In case you want the class CustomClass itself (or a subtype), then you should write: from typing import Type # you have to import Type def FuncA(arg: Type[CustomClass]): # ^ CustomClass (class object) itself Like it … Read more
You can look in sys.types or use TYPE_ID: IF TYPE_ID(N’MyType’) IS NULL … Just a precaution: using type_id won’t verify that the type is a table type–just that a type by that name exists. Otherwise gbn’s query is probably better.