From: | Tommi Mäkitalo <t(dot)maekitalo(at)epgmbh(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: migrating from MSSql |
Date: | 2001-11-21 07:20:27 |
Message-ID: | 3BFB55BB.7080906@epgmbh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
use:
SELECT FirstName || ' ' + || LstName AS "Customer Name" FROM tblCustomers
Tommi
PostgreSQL List User wrote:
>Hi there! I just started using postgres and I'm loving it. I really want
>to go all open source at the office... I have a database in MSSQL which
>I was able to export succesfully using the DTServices... But the client
>application which contains a lot of SQL statements crashes every now and
>then becouse of sql syntax...
>
>Most of the problems I've benn able to fix, but there are a couple I
>would like to ask about:
>
>I have some querys that go like:
>
>SELECT FirstName + ' ' + LastName AS [Customer Name] FROM tblCustomers
>
>How should I write something that does the same (joins both fields with
>a space in the middle and calls the resulting field 'Customer Name') in
>a way that postgreSQL can understand?
>
>Thanks to all in advance!
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2001-11-21 07:44:08 | Re: indexing bug? |
Previous Message | Arsalan Zaidi | 2001-11-21 07:13:44 | indexing bug? |