From: | Jason Earl <jason(dot)earl(at)simplot(dot)com> |
---|---|
To: | PostgreSQL List User <pguser(at)rwsoft-online(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: migrating from MSSql |
Date: | 2001-11-21 01:34:56 |
Message-ID: | 878zd09a9r.fsf@npa01zz001.simplot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
SELECT FirstName || ' ' || LastName AS "Customer Name" FROM tblCustomers;
Should do what you want.
PostgreSQL List User <pguser(at)rwsoft-online(dot)com> writes:
> 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 | mike sears | 2001-11-21 02:12:31 | select extract and subqueries |
Previous Message | Thomas T. Thai | 2001-11-21 01:30:11 | Re: migrating from MSSql |