You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is there any way to create a ROW with no fields? When I pass no fields to ROW,
-- In Trino
SELECT ROW();
I get the following error:
FUNCTION_NOT_FOUND: line 1:8: Function 'row' not registered
In some other DBs with a type similar to Trino's ROW, I can create an empty structure with no fields. For example, in Redshift, I can create an OBJECT (similar to Trino's ROW) with no fields.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Is there any way to create a ROW with no fields? When I pass no fields to
ROW
,I get the following error:
In some other DBs with a type similar to Trino's
ROW
, I can create an empty structure with no fields. For example, in Redshift, I can create anOBJECT
(similar to Trino'sROW
) with no fields.Output:
Beta Was this translation helpful? Give feedback.
All reactions