query

Поиск
Список
Период
Сортировка
От superboy143 (sent by Nabble.com)
Тема query
Дата
Msg-id 2798161.post@talk.nabble.com
обсуждение исходный текст
Ответы Re: query  (Richard Huxton <dev@archonet.com>)
Re: query  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-sql
Hello, <br /><br />I have a table in which I have a field with format like 100101. It has many values like 100101,
100102,100103, 100201, 100202, 100301. I have to write a query such that I have to get only distinct values such that
theycontain only the substring I need. If I give 10 as substring, then it should return only 100101 or 100102 but not
bothi.e if the last two characters are not same it should not return both of them. It should return only values
startingwith 10 the middle two values should be distinct and the last two characters may be anything. <br /><hr
align="left"width="300" /> View this message in context: <a
href="http://www.nabble.com/query-t1074932.html#a2798161">query</a><br/> Sent from the <a
href="http://www.nabble.com/PostgreSQL---sql-f777.html">PostgreSQL- sql</a> forum at Nabble.com.  

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: no notnull values, invalid stats?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: query