| 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: | Whole Thread | Raw Message | 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!
| 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! |