Re: left() in postgres

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: left() in postgres
Дата
Msg-id 20021025102422.B37463-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Re: left() in postgres  (Peter Nixon <listuser@peternixon.net>)
Список pgsql-general
On Fri, 25 Oct 2002, Peter Nixon wrote:

> I guess I don't understand how to use it properly. can anyone give me some
> more help. When I fire off the following query (at a database of radius
> records)
>
>
> SELECT substring('CalledStationId' from 2 for 3) FROM calls WHERE

I think you'd want something like:
substring(CalledStationId from 1 for 3)

Putting it in single quotes makes it a literal, you were asking for
positions 2-4 in the literal string 'CalledStationId' => 'all'.



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: left() in postgres
Следующее
От: PD Miller
Дата:
Сообщение: Re: left() in postgres