[HACKERS] timestamp format escape rules

2015-03-12 Thread Rikard Pavelic
7;m asking this since we often return nested records directly from Postgres and when reading deeply nested records, we are mostly skipping on quotes/escapes. Regards, Rikard -- Rikard Pavelic https://dsl-platform.com/ http://templater.info/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@pos

[HACKERS] Rewriting existing table tuples on alter type

2012-06-30 Thread Rikard Pavelic
How hard would it be to rewrite table content on composite attribute type change? For simple use cases: create type complex as (i int, j int); create table numbers (c complex); insert into numbers values(row(1,2)); I can work around alter complex from int to bigint "fairly" easy with alter type