Re: SELECT CAST(123 AS char) -> 1
От
Gregory Stark
Тема
Re: SELECT CAST(123 AS char) -> 1
Дата
Msg-id
877ihapik6.fsf@oxford.xeocode.com
Ответ на
Re: SELECT CAST(123 AS char) -> 1 (Ken Johanson)
Список
Дерево обсуждения
SELECT CAST(123 AS char) -> 1 Ken Johanson <pg-user@kensystem.com>
Re: SELECT CAST(123 AS char) -> 1 Tom Lane <tgl@sss.pgh.pa.us>
Re: SELECT CAST(123 AS char) -> 1 Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: SELECT CAST(123 AS char) -> 1 Tom Lane <tgl@sss.pgh.pa.us>
Re: SELECT CAST(123 AS char) -> 1 Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: SELECT CAST(123 AS char) -> 1 Ken Johanson <pg-user@kensystem.com>
Re: SELECT CAST(123 AS char) -> 1 Tom Lane <tgl@sss.pgh.pa.us>
Re: SELECT CAST(123 AS char) -> 1 Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: SELECT CAST(123 AS char) -> 1 Ken Johanson <pg-user@kensystem.com>
Re: SELECT CAST(123 AS char) -> 1 Gregory Stark <stark@enterprisedb.com>
Re: SELECT CAST(123 AS char) -> 1 Ken Johanson <pg-user@kensystem.com>
Re: SELECT CAST(123 AS char) -> 1 "Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>
Re: SELECT CAST(123 AS char) -> 1 Ken Johanson <pg-user@kensystem.com>
Re: SELECT CAST(123 AS char) -> 1 "Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>
Re: SELECT CAST(123 AS char) -> 1 Ken Johanson <pg-user@kensystem.com>
Re: SELECT CAST(123 AS char) -> 1 Andrew Sullivan <ajs@crankycanuck.ca>
Re: SELECT CAST(123 AS char) -> 1 Ken Johanson <pg-user@kensystem.com>
Re: SELECT CAST(123 AS char) -> 1 Alvaro Herrera <alvherre@commandprompt.com>
Re: SELECT CAST(123 AS char) -> 1 Ken Johanson <pg-user@kensystem.com>
Re: SELECT CAST(123 AS char) -> 1 Alvaro Herrera <alvherre@commandprompt.com>
Re: SELECT CAST(123 AS char) -> 1 Richard Huxton <dev@archonet.com>
Re: SELECT CAST(123 AS char) -> 1 Tom Lane <tgl@sss.pgh.pa.us>
Re: SELECT CAST(123 AS char) -> 1 Richard Huxton <dev@archonet.com>
Re: SELECT CAST(123 AS char) -> 1 Ken Johanson <pg-user@kensystem.com>
Re: SELECT CAST(123 AS char) -> 1 "Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>
Re: SELECT CAST(123 AS char) -> 1 Ken Johanson <pg-user@kensystem.com>
Re: SELECT CAST(123 AS char) -> 1 Tom Lane <tgl@sss.pgh.pa.us>
Re: SELECT CAST(123 AS char) -> 1 Ken Johanson <pg-user@kensystem.com>
Re: SELECT CAST(123 AS char) -> 1 Martijn van Oosterhout <kleptog@svana.org>
"Ken Johanson" writes: > Tom Lane wrote: > >> SQL92 section 6.1 quoth >> >> ::= >> CHARACTER [ ] >> | CHAR [ ] >> >> ... >> >> 4) If is omitted, then a of 1 is implicit. >> >> Therefore, writing just "char" is defined as equivalent to "char(1)". > > However when length is not defined I think it will generally be safe(r) to > auto-size. In the grand scheme auto-size creates much more sensible output than > a 1-char wide one (even if right-padded to max char-length of the type). Sure, but you're a prime candidate for understanding the value of following the spec if you're trying to write software that works with multiple databases. It's a bit crazy to be using CHAR and then complaining about padding... That's what CHAR is for. If the other database doesn't support varchar it's so far from the SQL spec that writing something portable between it and something else is probably hopeless. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning
В списке pgsql-general по дате отправления
