title: How to return a List[User] when using sql with slick
body: <p>I can seem to get how I can return a List[User] from a raw sql query.</p>
  
  <pre><code>implicit val getUserResult = GetResult(r =&gt; User(r.nextInt, ....))
  
  sql"""
  select * from users where id =1
  
  """.as[User]
  </code></pre>
  
  <p>This seems to compile fine, but if I change this to return a list and not a single result I get an error.</p>
  
  <pre><code>.as[List[User]]
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>could not find implicit value for parameter rconv: scala.slick.jdbc.GetResult[List[User]]
  </code></pre>
  
  <p>How can I change the implicit GetResult to return a list?</p>
  
  <p><b>Update</b></p>
  
  <p>So I created the implicit like:</p>
  
  <p>implicit val getUserResult = GetResult( r => User(r.nextInt, ....))</p>
  
  <p>val query: StaticQuery0[User] = sql"....."</p>
  
  <p>query.list()</p>
  
  <p>I can this error:</p>
  
  <pre><code>[PSQLException: Bad value for type int : asdf asdfs]
  </code></pre>
  
  <p>In psql I can see that I have "asdf asdfs" in some columns, but not INT columns.  If things compile I'm not sure why I am getting this error, looks like a bug?</p>