mydb=# INSERT INTO test_tsvector (name,raw,vector) VALUES ('mary','love dancing',to_tsvector('Love Dancing')); mydb=# SELECT * FROM test_tsvector WHERE name='mary'; name | raw | vector ---+---+--- mary | love dancing | 'danc':2 'love':1 mydb=# INSERT INTO test_tsvector...
Version 9.4 CREATE FUNCTION - ERROR: type xxxx does not exist create function started10 years ago 10 years ago Joe Conway 1 reply BUG #13754: Postgres possibly accepts a typo as valid input started10 years ago 10 years ago Tom Lane
bill@bill=>select * from test; ERROR: relation 'test' does not exist LINE 1: select * from test; ^ bill@bill=>select * from TEST; ERROR: relation 'test' does not exist LINE 1: select * from TEST; ^ bill@bill=>select * from 'TEST'; id | info ---+--- (0 rows) 1. 2. ...