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
And a table storing array of said custom type as a column:
CREATETABLEtwitter_threadsAS (
tweets twitter_tweet[] NOT NULL DEFAULT '{}::twitter_tweet[]'
)
How can I insert or select an array of twitter_tweet-s?
I've tried different combinations of sql.array / sql.join / etc, but none of them seem to work. Currently the only option I see is to build a raw SQL and insert it as-is, which is quite dangerous and clunky.
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
-
Let's say I have a custom type:
And a table storing array of said custom type as a column:
How can I insert or select an array of
twitter_tweet
-s?I've tried different combinations of
sql.array
/sql.join
/ etc, but none of them seem to work. Currently the only option I see is to build a raw SQL and insert it as-is, which is quite dangerous and clunky.Beta Was this translation helpful? Give feedback.
All reactions