migrating from MSSql - Mailing list pgsql-general

From PostgreSQL List User
Subject migrating from MSSql
Date
Msg-id Pine.LNX.4.21.0111201340170.642-100000@rwdeb1.rwsoft-online.com
Whole thread Raw
Responses Re: migrating from MSSql  ("Thomas T. Thai" <tom@minnesota.com>)
Re: migrating from MSSql  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: migrating from MSSql  (Jason Earl <jason.earl@simplot.com>)
List pgsql-general
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!


pgsql-general by date:

Previous
From: "Andrew G. Hammond"
Date:
Subject: Re: Creating/Using functions in pl/pgsql
Next
From: "Thomas T. Thai"
Date:
Subject: Re: migrating from MSSql