I'm having a rough time getting multiple rows and ...
# help
d
I'm having a rough time getting multiple rows and I don't think I should be.
Copy code
final PostgrestResponse res = await _usersEwkb
        .select(columns)
        // .neq("user_id", callingUser.userId)
        // .limit(16)
        // .withConverter((data) => UserModel.fromJson(data))
        .execute();
I keep getting
Copy code
PostgrestError(message: JSON object requested, multiple (or no) rows returned, code: null, details: Results contain 2 rows, appl
n
Thread automatically created by @DanMossa in #843999948717555735.
d
But there's definitely nothing that indicates this should be a problem?
Oof it's my view
n
Thread was archived by @DanMossa. Anyone can send a message to unarchive it.
DMoney (2022-03-11)
d
Wait a minute, I don't see why my view is ruining this.
Copy code
CREATE VIEW users_ewkb_view AS
 SELECT
    users.user_id,
    users.first_name,
    users.profile_picture_urls,
    users.date_of_birth,
    st_asewkt(users.location) AS location
   FROM public.users;
n
Unable to return multiple rows
d
Holy hell it's a global variable that's leaking
n
Thread was archived by @DanMossa. Anyone can send a message to unarchive it.