RE: [SQL] substring

Поиск
Список
Период
Сортировка
От Michael J Davis
Тема RE: [SQL] substring
Дата
Msg-id 93C04F1F5173D211A27900105AA8FCFC14541D@lambic.prevuenet.com
обсуждение исходный текст
Список pgsql-sql
try:

select a, substring(a, 1, position('_' in a) -1) from table_a;

I have not tested this.  Not sure if the parameters to substring are
correct.  Also not sure if the -1 is needed.

> -----Original Message-----
> From:    Nuchanard Chiannilkulchai [SMTP:nuch@valigene.com]
> Sent:    Monday, April 26, 1999 8:57 AM
> To:    pgsql-sql@hub.org
> Subject:    [SQL] substring
> 
> Hello,
> 
>     How should I do my query to put a substring value in a field, in
> postgres ( I have 6.4) ?
> 
> I have  in table table_a
> a
> ----------------
> 98-004_c136
> P124_154
> 98-005_c171
> 
> and i want to select only the text before the underscore:
> 
> in sybase, this should be
>  select a, substring(a,1,charindex('_',a)-1)  from table_a
>  a
>  ---------------- ----------------
>  98-004_c136      98-004
>  98-005_c171      98-005
>  P124_154         P124
> 
>     Thanks a lot,
>     Nuch
> 
> 
> 


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

Предыдущее
От: "Justin Long"
Дата:
Сообщение: CURRVAL(INDEX)
Следующее
От: Christophe Labouisse
Дата:
Сообщение: Strange behavior