Momjian; 'David Fetter'; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function
PostgreSQL runs on machines that use EBCDIC?
On Mon, Oct 10, 2005 at 04:26:15PM +0100,
[EMAIL PROTECTED] wrote:
Here is a direct quote from the ORACLE manual:
Tom Lane wrote:
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
And you might want to make it a project at http://pgfoundry.org so
others can make use of it. You might also want to define it as accepting
an array; I think that would allow you to accept any number of
parameters.
I think Ton
Bruce Momjian writes:
>> Where does textcat fit into things?
> textcat is the internal function mapped to ||. It isn't documented
> anywhere for general use. It does show up in psql \df though. I
> suppose the bug reporter could use that, but it isn't portable to other
> database systems.
tex
Klint Gore wrote:
> On Mon, 10 Oct 2005 23:45:03 -0400 (EDT), Bruce Momjian
> wrote:
> > Oracle has a tendency to keep things around forever, which is nice, but
> > over the years it produces a system with lots of strange features that
> > make the system hard to use. PostgreSQL has a tendency t
On Mon, 10 Oct 2005 23:45:03 -0400 (EDT), Bruce Momjian
wrote:
> Oracle has a tendency to keep things around forever, which is nice, but
> over the years it produces a system with lots of strange features that
> make the system hard to use. PostgreSQL has a tendency to remove old,
> unused stuff
[EMAIL PROTECTED] wrote:
> Here is a direct quote from the ORACLE manual:
>
> On most platforms, the concatenation operator is two solid
> vertical bars, as shown in Table 3-3. However, some IBM platforms use
> broken vertical bars for this operator. When moving SQL script files
> between systems
19
> > To: [EMAIL PROTECTED]
> > Cc: Bruce Momjian; 'David Fetter'; pgsql-bugs@postgresql.org
> > Subject: Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function
> >
> >
> > PostgreSQL runs on machines that use EBCDIC?
> >
> >
> -Original Message-
> From: Kevin Grittner [mailto:[EMAIL PROTECTED]
> Sent: 10 October 2005 15:50
> To: [EMAIL PROTECTED]; pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function
>
>
> If you are striving for port
ober 2005 18:19
> To: [EMAIL PROTECTED]
> Cc: Bruce Momjian; 'David Fetter'; pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function
>
>
> PostgreSQL runs on machines that use EBCDIC?
>
> On Mon, Oct 10, 2005 at 0
PostgreSQL runs on machines that use EBCDIC?
On Mon, Oct 10, 2005 at 04:26:15PM +0100, [EMAIL PROTECTED] wrote:
> Here is a direct quote from the ORACLE manual:
>
>
> On most platforms, the concatenation operator is two solid vertical bars, as
> shown in Table 3-3. However, some IBM platforms u
Here is a direct quote from the ORACLE manual:
On most platforms, the concatenation operator is two solid vertical bars, as
shown in Table 3-3. However, some IBM platforms use broken vertical bars for
this operator. When moving SQL script files between systems having different
character sets,
If you are striving for portability, perhaps you are using Java as your
programming language. If so, you could benefit from the fact that the
volunteers in the PostgreSQL community have put the effort into the
JDBC driver to support the escape sequence for portable string
concatenation. This work
Tony Marston wrote:
> > which Oracle supports and MySQL can be made to support via a
> > runtime option.
>
> They also both support CONCAT() because there are sometimes difficulties in
> dealing with vertical bars in the character sets used by certain operating
> systems and file systems. If enou
> -Original Message-
> From: David Fetter [mailto:[EMAIL PROTECTED]
> Sent: 09 October 2005 18:20
> To: Tony Marston
> Cc: 'Tom Lane'; 'Jim C. Nasby'; pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function
On Sun, Oct 09, 2005 at 11:05:41AM +0100, Tony Marston wrote:
>
> > "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > > And you might want to make it a project at http://pgfoundry.org
> > > so others can make use of it. You might also want to define it
> > > as accepting an array; I think that would
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: 08 October 2005 22:30
> To: Jim C. Nasby
> Cc: Tony Marston; pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #1947: Enhancement Request - CONCAT()
> function
>
>
> "Jim C
Tony Marston wrote:
> It is a well-known fact that every database vendor includes their own
> "extensions" to the SQL standard simply because they want to offer more
> functionality to their users, and they can't wait for it to be formally
> documented in the standard.
On the other hand, it would
> -Original Message-
> From: David Fetter [mailto:[EMAIL PROTECTED]
> Sent: 08 October 2005 22:16
> To: Tony Marston
> Cc: pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function
>
>
> On Sat, Oct 08, 2005 at 12:
On Sat, Oct 08, 2005 at 11:11:58PM +0100, Tony Marston wrote:
>
> > -Original Message-
> > >
> > > The following bug has been logged online:
> > >
> > > Bug reference: 1947
> > > Logged by: Tony Marston
> > > Email address: [EMAIL PROTECTED]
> > > PostgreSQL version: 8
On Sat, Oct 08, 2005 at 04:33:10PM -0400, Tom Lane wrote:
> "Tony Marston" <[EMAIL PROTECTED]> writes:
> > I would like the option to use CONCAT(field1, ' ', field2) instead of the
> > vertical bar syntax (field1 || ' ' || field2) as this is also available in
> > other popular databases (MySQL, ORA
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> And you might want to make it a project at http://pgfoundry.org so
> others can make use of it. You might also want to define it as accepting
> an array; I think that would allow you to accept any number of
> parameters.
I think Tony is trying to avoid
On Sat, Oct 08, 2005 at 12:39:40PM +0100, Tony Marston wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1947
> Logged by: Tony Marston
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.0.3
> Operating system: Windows XP
> Description:En
"Tony Marston" <[EMAIL PROTECTED]> writes:
> I would like the option to use CONCAT(field1, ' ', field2) instead of the
> vertical bar syntax (field1 || ' ' || field2) as this is also available in
> other popular databases (MySQL, ORACLE).
|| is the SQL standard, CONCAT() is not. But feel free to
The following bug has been logged online:
Bug reference: 1947
Logged by: Tony Marston
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Windows XP
Description:Enhancement Request - CONCAT() function
Details:
I would like the option to use
24 matches
Mail list logo
