From: Michael J Davis <michael.j.davis@tvguide.com>
To: 'Nuchanard Chiannilkulchai' <nuch@valigene.com>
To: pgsql-sql@hub.org
Subject: RE: [SQL] substring
Date: Mon, 26 Apr 1999 14:35:16 -0500
Message-ID: <93C04F1F5173D211A27900105AA8FCFC14541D@lambic.prevuenet.com> (raw)
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
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: michael.j.davis@tvguide.com, nuch@valigene.com, pgsql-sql@hub.org
Subject: RE: [SQL] substring
In-Reply-To: <93C04F1F5173D211A27900105AA8FCFC14541D@lambic.prevuenet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox