string functions - Mailing list pgsql-novice

From Michael Fuchs
Subject string functions
Date
Msg-id 003d01c21125$c734e5b0$da2821d5@fubox
Whole thread Raw
Responses Re: string functions
List pgsql-novice
hi there!
i've got some email adresses in my db, but i just want everything before
the '@' to be returned.
example:

firstname.lastname@mydomain.tld -> firstname.lastname

what must my select statement look like?

i tried something like
"SELECT TRIM(leading '@' from email) FROM ..." needless to say that this
doesn't work.

thanks in advance!

PS: looking at "user-7.2-A4.pdf" and "user-7.2-US.pdf" in
ftp://ftp.at.postgresql.org/db/www.postgresql.org/pub/doc/current/ i had
to find out that many examples cannot be read because of too narrow
columns. are there other versions of these docs available (html, rtf,
...)?

--michael


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: no value in string
Next
From: "Joshua b. Jore"
Date:
Subject: Re: string functions