Re: Re: Advice - indexing on varchar fields where only last x characters known

From: skinner(at)britvault(dot)co(dot)uk (Craig R(dot) Skinner)
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Re: Advice - indexing on varchar fields where only last x characters known
Date: 2013-10-18 11:37:58
Message-ID: 20131018113758.GA958@teak.britvault.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message David Johnston 2013-10-18 13:44:12 Re: Advice - indexing on varchar fields where only last x characters known
Previous Message Gary Stainburn 2013-10-18 07:22:48 Re: Re: Advice - indexing on varchar fields where only last x characters known