Postgres Pro
Downloads
Home   >   mailing lists

Re: Best Fit SQL query statement - Mailing list pgsql-sql

From Rodrigo De León
Subject Re: Best Fit SQL query statement
Date
Msg-id 1186413312.263516.180000@l70g2000hse.googlegroups.com
Whole thread Raw
List pgsql-sql
Tree view 
On Aug 6, 3:57 am, Kiran <kumar.m.ki...@gmail.com> wrote:
> and if I query on 98456 the result must be 98456,
> However if I query on 98455 the result must be 9845
> and If I query 9849 the result must be 984

SELECT MAX(t1) FROM t1WHERE '9849' LIKE t1 || '%';

pgsql-sql by date:

Previous
From: Steve Midgley
Date:
Subject: Re: Increment a sequence by more than one
Next
From: Ranieri Mazili
Date:
Subject: Using function like where clause