migrating from MSSql

From: PostgreSQL List User <pguser(at)rwsoft-online(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: migrating from MSSql
Date: 2001-11-20 19:41:07
Message-ID: Pine.LNX.4.21.0111201340170.642-100000@rwdeb1.rwsoft-online.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Russell Miller 2001-11-20 19:44:59 Re: Slightly OT: outer joins
Previous Message Brent R. Matzelle 2001-11-20 19:10:29 Re: A newbie's opinion - postgres NEEDS a Windows binary!