ahoward (owner)

Revisions

gist: 225385 Download_button fork
public
Public Clone URL: git://gist.github.com/225385.git
Embed All Files: show embed
Text only #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13

qval_development=# SELECT ts_index FROM "users" WHERE "email" LIKE 'ara.t.howard@gmail.com' limit 1;
          ts_index          
----------------------------
 'ara.t.howard@gmail.com':1
(1 row)
 
 
 
qval_development=# SELECT * FROM "users" WHERE (ts_index @@ to_tsquery('ara'));
 id | email | crypted_password | salt | created_at | updated_at | deleted_at | remember_token | remember_token_expires_at | activation_code | promotion_code | activated_at | state | ts_index 
----+-------+------------------+------+------------+------------+------------+----------------+---------------------------+-----------------+----------------+--------------+-------+----------
(0 rows)