From: | PostgreSQL List User <pguser(at)rwsoft-online(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | THANKS! Was: Re: migrating from MSSql |
Date: | 2001-11-21 10:17:54 |
Message-ID: | Pine.LNX.4.21.0111210415310.12583-100000@rwdeb1.rwsoft-online.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks to all of you! I got a lot of responses and very fast! Which is
great! Again thanks! This certainly looks like a great list...
Alex.
On Tue, 20 Nov 2001, Stephan Szabo wrote:
> 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.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | marpet | 2001-11-21 10:25:20 | Re: A newbie's opinion - postgres NEEDS a Windows binary! |
Previous Message | Martijn van Oosterhout | 2001-11-21 07:44:08 | Re: indexing bug? |