Re: Re: Advice - indexing on varchar fields where only last x characters known - Mailing list pgsql-sql

On 2013-10-18 Fri 08:22 AM |, Gary Stainburn wrote:
> 
> While the reverse() option may work for searching it will not be ideal for 
> foreign keys.
> 

Use an integer (serial) as the PK/FK & unique the VIN.

Then you can use reverse() for searching.

Kitcars, boat/garden/equipment/truck trailers, caravans, etc.
might not have any VIN.