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

Поиск
Список
Период
Сортировка
От skinner@britvault.co.uk (Craig R. Skinner)
Тема Re: Re: Advice - indexing on varchar fields where only last x characters known
Дата
Msg-id 20131018113758.GA958@teak.britvault.co.uk
обсуждение исходный текст
Ответ на Re: Re: Advice - indexing on varchar fields where only last x characters known  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
Список 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.

В списке pgsql-sql по дате отправления:

Предыдущее
От: Gary Stainburn
Дата:
Сообщение: Re: Re: Advice - indexing on varchar fields where only last x characters known
Следующее
От: David Johnston
Дата:
Сообщение: Re: Advice - indexing on varchar fields where only last x characters known