Re: migrating from MSSql - Mailing list pgsql-general

From Stephan Szabo
Subject Re: migrating from MSSql
Date
Msg-id 20011120172233.B60531-100000@megazone23.bigpanda.com
Whole thread Raw
In response to migrating from MSSql  (PostgreSQL List User <pguser@rwsoft-online.com>)
Responses THANKS! Was: Re: migrating from MSSql
List pgsql-general
On Tue, 20 Nov 2001, 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?

select FirstName || ' ' || LastName AS "Customer Name" FROM tblCustomers
should do it.



pgsql-general by date:

Previous
From: "Thomas T. Thai"
Date:
Subject: Re: migrating from MSSql
Next
From: Jason Earl
Date:
Subject: Re: migrating from MSSql