Displaying 3 results from an estimated 3 matches for "id_list".
Did you mean:
i_list
2008 Oct 13
2
Subset based on items in a list.
R-help:
I have a variable ("ID_list") containing about 1800 unique numbers, and a
143066x29 data frame. One of the columns ("ID") in my data frame contains a
list of ids, many of which appear more than once. I'd like to find the
subset of my data frame for which "ID" matches one of the numbers in
"...
2011 Feb 17
1
Select distinict on not chainable with order method
...rand_id)
beers.*")
Using this scope alone is working correct, however chaining that scope
with order method, throws strange error:
Beer.with_unique_brand.order("created_at"):
Beer Load (1.1ms) SELECT * FROM (SELECT DISTINCT ON
(beers.brand_id) beers.* FROM "beers") AS id_list ORDER BY
id_list.alias_0
PGError: ERROR: column id_list.alias_0 does not exist
LINE 1: ...and_id) beers.* FROM "beers") AS id_list ORDER BY
id_list.al...
^
: SELECT * FROM (SELECT DISTINCT ON (beers.brand_id) beers.* FROM
"...
2007 Dec 12
2
possible bug in eager loading
...his produces:
User Load IDs For Limited Eager Loading (74.648762) SELECT * FROM
(SELECT DISTINCT ON (users.id) users.id, username AS alias_0 FROM users
LEFT OUTER JOIN user_data ON user_data.user_id = users.id LEFT OUTER
JOIN user_data_fields ON user_data_fields.id = user_data.field_id ) AS
id_list ORDER BY id_list.alias_0 DESC LIMIT 50
User Load Including Associations (0.026093) SELECT users."id" AS
t0_r0, users."username" AS t0_r1, users."password" AS t0_r2, <lots of
more fields>, user_data."id" AS t1_r0, user_data."entered_when"...