peopleTable

Return a new query containing the elements from both operands. Duplicate elements are preserved.

Get the "raw" table row that represents the table itself, as opposed to a Path for a variable of the table's type. This method should generally not be called from user code.

The number of distinct elements of the query.

Remove duplicate elements. When used on an ordered Query, there is no guarantee in which order duplicates are removed. This method is equivalent to distinctOn(identity).

Remove duplicate elements which are the same in the given projection. When used on an ordered Query, there is no guarantee in which order duplicates are removed.

Select all elements except the first num ones.

Select all elements except the first num ones.

Select all elements except the first num ones.

Encode a reference into this Rep.

Test whether this query is non-empty.

Select all elements of this query which satisfy a predicate. Unlike withFilter, this method only allows Rep-valued predicates, so it guards against the accidental use plain Booleans.

Applies the given filter function, if the boolean parameter p evaluates to true. If not, the filter will not be part of the query.

Applies the given filterNot function, if the boolean parameter p evaluates to true. If not, the filter will not be part of the query.

Applies the given filterNot, if the Option value is defined. If the value is None, the filter will not be part of the query.

Applies the given filter, if the Option value is defined. If the value is None, the filter will not be part of the query.

Build a new query by applying a function to all elements of this query and using the elements of the resulting queries. This corresponds to an implicit inner join in SQL.

Specify part of a select statement for update and marked for row level locking

Partition this query into a query of pairs of a key and a nested query containing the elements for the key, according to some discriminator function.

Join two queries with a cross join or inner join. An optional join predicate can be specified later by calling on.

Join two queries with a full outer join. An optional join predicate can be specified later by calling on. Both sides of the join are lifted to an Option. If at least one element on either side matches the other side, all matching elements are returned as Some, otherwise a single None row is returned.

Join two queries with a left outer join. An optional join predicate can be specified later by calling on. The right side of the join is lifted to an Option. If at least one element on the right matches, all matching elements are returned as Some, otherwise a single None row is returned.

Join two queries with a right outer join. An optional join predicate can be specified later by calling on. The left side of the join is lifted to an Option. If at least one element on the left matches, all matching elements are returned as Some, otherwise a single None row is returned.

The total number of elements (i.e. rows).

Build a new query by applying a function to all elements of this query.

The total number of elements (i.e. rows).

Sort this query according to a function which extracts the ordering criteria from the query's elements.

Sort this query according to a the ordering of its elements.

Force a subquery to be created when using this Query as part of a larger Query. This method should never be necessary for correctness. If a query works with an explicit .subquery call but fails without, this should be considered a bug in Slick. The method is exposed in the API to enable workarounds to be written in such cases.

Select the first num elements.

Select the first num elements.

Select the first num elements.

Change the collection type to build when executing the query.

Returns a string representation of the object.

The default representation is platform dependent.

Return a new query containing the elements from both operands. Duplicate elements are eliminated from the result.

Return a new query containing the elements from both operands. Duplicate elements are preserved.

Select all elements of this query which satisfy a predicate. This method is used when desugaring for-comprehensions over queries. There is no reason to call it directly because it is the same as filter.

Return a query formed from this query and another query by combining corresponding elements in pairs.

Return a query formed from this query and another query by combining corresponding elements with the specified function.

Zip this query with its indices (starting at 0).

Get the Node for this Rep.