i've got some email adresses in my db, but i just want everything before
the '@' to be returned.
firstname(dot)lastname(at)mydomain(dot)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
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,
pgsql-novice by date
|Next:||From: stev knowles||Date: 2002-06-10 19:27:53|
|Subject: no value in string|
|Previous:||From: Joel Burton||Date: 2002-06-10 15:14:19|
|Subject: Re: Conditional Join (or something along those lines)|