Magnus Hagander <magnus@xxxxxxxxxxxx> writes: > On Sun, Jun 13, 2010 at 17:42, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> ... (We presumably want >> timezone to default to the system timezone setting, but I wonder how >> we should make that work --- should an empty string be treated as >> meaning that?) > Umm. NULL could be made to mean that, or we could provicde two > different versions - one that takes TZ and one that doesn't. Using NULL like that seems a bit awkward: for one thing it'd mean the function couldn't be STRICT, and also it'd be bizarre that only this one argument could be null without leading to a null result. And two separate functions isn't good either. Basically, I think it's important that there be a way to specify an explicit parameter value that behaves identically to the default. > And a third, construct_time(), no? Yeah, maybe ... do you think there's any demand for it? regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
