Re: [BUGS] BUG #1272: text + numeric wrong behaviour

2004-10-01 Thread Damjan Pipan
mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 29, 2004 5:38 PM > To: Damjan Pipan > Cc: [EMAIL PROTECTED] > Subject: Re: [BUGS] BUG #1272: text + numeric wrong behaviour > > "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > > first select does no

Re: [BUGS] BUG #1272: text + numeric wrong behaviour

2004-09-29 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > first select does not return amount, second does. Huh? I get regression=# SELECT * FROM a1; description | amount -+ asdasd | 370.00 (1 row) regression=# SELECT description::varchar, amount FROM a1; description | am