Re: RDBMS comparison tool

2013-01-05 Thread Darren Duncan
On 2013.01.04 4:17 PM, Lyle wrote: On 01/01/2013 03:12, Greg Sabino Mullane wrote: Lyle wrote: Similar situation for PostgreSQL character. Yep. Reviewing the PostgreSQL documentation on CHARACTER it mentions things like short, long and very long character strings, but lacks detail so I've

Re: RDBMS comparison tool

2013-01-05 Thread Lyle
On 05/01/2013 10:41, Darren Duncan wrote: My understanding about Postgres either compressing strings or using toast segments for longer ones is that this is just an internal implementation detail and that user-facing concepts like data types should be ignoring these differences. Character

Re: RDBMS comparison tool

2013-01-05 Thread Darren Duncan
On 2013.01.05 5:39 AM, Lyle wrote: On 05/01/2013 10:41, Darren Duncan wrote: Since the SQL standard, as well as some other programming languages, define decimal as being exact numeric, then it is absolutely wrong to map them to either FLOAT or DOUBLE. In fact, in Perl 5 the only native type