Re: [BUGS] Bug in concat operator for Char? -- More Info

2004-07-21 Thread Jean-Luc Lachance
This means that there is no more difference between CHAR(N) and VARCHAR(N). To bad... '1 ' sould be different from '1'. Tom Lane wrote: Josh Berkus <[EMAIL PROTECTED]> writes: Are these changes intentional, Yes. We've been moving more and more steadily towards the notion that trailing spaces in

[BUGS] Problem: Sequence X Rule Reference!

2004-07-21 Thread Junior - Cotrijui
/*** *** Hello my friends, I have a problem, please, see the example above: ***/ creat

Re: [BUGS] Bug in concat operator for Char? -- More Info

2004-07-21 Thread Stephan Szabo
On Wed, 21 Jul 2004, Tom Lane wrote: > Josh Berkus <[EMAIL PROTECTED]> writes: > > Are these changes intentional, > > Yes. We've been moving more and more steadily towards the notion that > trailing spaces in char(n) values are insignificant noise. If you think > that trailing spaces are signif

Re: [BUGS] Bug in concat operator for Char? -- More Info

2004-07-21 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > On Wed, 21 Jul 2004, Tom Lane wrote: >> Yes. We've been moving more and more steadily towards the notion that >> trailing spaces in char(n) values are insignificant noise. If you think >> that trailing spaces are significant, you shouldn't be using char

Re: [BUGS] Bug in concat operator for Char? -- More Info

2004-07-21 Thread Stephan Szabo
On Wed, 21 Jul 2004, Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > On Wed, 21 Jul 2004, Tom Lane wrote: > >> Yes. We've been moving more and more steadily towards the notion that > >> trailing spaces in char(n) values are insignificant noise. If you think > >> that trailing sp

Re: [BUGS] Bug in concat operator for Char? -- More Info

2004-07-21 Thread Andreas Pflug
Tom Lane wrote: Food for thought: in 7.4, regression=# select ('X '::char) = ('X'::char); ?column? -- t (1 row) regression=# select ('Y '::char) = ('Y'::char); ?column? -- t (1 row) regression=# select ('X '::char || 'Y '::char) = ('X'::char || 'Y'::char); ?column?

Re: [BUGS] Bug in concat operator for Char? -- More Info

2004-07-21 Thread Darcy Buskermolen
On July 21, 2004 08:22 am, Tom Lane wrote: > > IMHO the bottom line here is that the SQL-spec behavior of type char(N) > is completely brain-dead. Practically all of the questions in this area > would go away if people used varchar(N) or text to store their data. > > regards,

[BUGS] BUG #1199: pgAdmin problem

2004-07-21 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1199 Logged by: Marko Zmak Email address: [EMAIL PROTECTED] PostgreSQL version: 7.5 Dev Operating system: Windows XP Description:pgAdmin problem Details: I've installed PostgeSQL for Windows (using MSys a

Re: [BUGS] BUG #1199: pgAdmin problem

2004-07-21 Thread Andreas Pflug
PostgreSQL Bugs List wrote: The following bug has been logged online: Bug reference: 1199 Logged by: Marko Zmak Email address: [EMAIL PROTECTED] PostgreSQL version: 7.5 Dev Operating system: Windows XP Description:pgAdmin problem This list is for pgsql, not for pgadmin.

Re: [BUGS] Bug in concat operator for Char? -- More Info

2004-07-21 Thread Tom Lane
Andreas Pflug <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Food for thought: in 7.4, >> >> regression=# select ('X '::char) = ('X'::char); >> ?column? >> -- >> t >> (1 row) >> >> regression=# select ('Y '::char) = ('Y'::char); >> ?column? >> -- >> t >> (1 row) >> >> regre