How to format strings

From: Ian Willis <Ian(dot)Willis(at)ento(dot)csiro(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: How to format strings
Date: 2000-11-09 05:36:23
Message-ID: 3A0A37D7.EAA74691@ento.csiro.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Some time ago I saw the someone give an example of how to combine a
query result with test using sql.
What i have is a table with f_name varchar l_name varchar and I want the
result to say f_name(dot)l_name(at)mydomain(dot)com
Is this possible I will redirect the output to a textfile using the \o
option.
Thanks in advance for any help
--
Ian Willis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Warren Vanichuk 2000-11-09 05:52:43 Re: How to format strings
Previous Message Tom Lane 2000-11-09 05:25:33 Re: Relation 'pg_user' does not exist