Обсуждение: migrating from MSSql

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!

On Tue, 20 Nov 2001, PostgreSQL List User wrote:

> 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

in place of the + use the concat operator ||
you can find further help in the 'string' section in the user doc.

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.

SELECT FirstName || ' ' || LastName AS "Customer Name" FROM tblCustomers;

Should do what you want.

PostgreSQL List User <pguser@rwsoft-online.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@postgresql.org

Hi,

use:
  SELECT FirstName || ' ' + || LstName AS "Customer Name" FROM tblCustomers

Tommi

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?
>
>Thanks to all in advance!
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

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.
>
>
>