От: Tom Lane
Тема: Re: Analysis Function
Дата: ,
Msg-id: 14336.1276444704@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Analysis Function  (Magnus Hagander)
Ответы: Re: Analysis Function  (Magnus Hagander)
Список: pgsql-performance

Скрыть дерево обсуждения

Re: Analysis Function  (David Jarvis, )
 Re: Analysis Function  (Andy Colson, )
  Re: Analysis Function  (David Jarvis, )
   Re: Analysis Function  (David Jarvis, )
    Re: Analysis Function  (Heikki Linnakangas, )
     Query about index usage  (Jayadevan M, )
      Re: Query about index usage  ("Kevin Grittner", )
       Re: Query about index usage  (Jayadevan M, )
      Re: Query about index usage  (Greg Smith, )
      Re: Query about index usage  (Bob Lunney, )
 Re: Analysis Function  (Tim Landscheidt, )
  Re: Analysis Function  (David Jarvis, )
 Re: Analysis Function  (Tim Landscheidt, )
  Re: Analysis Function  (David Jarvis, )
   Re: Analysis Function  (David Jarvis, )
    Re: Analysis Function  (Tom Lane, )
     Re: Analysis Function  (David Jarvis, )
      Re: Analysis Function  (David Jarvis, )
       Re: Analysis Function  (Heikki Linnakangas, )
        Re: Analysis Function  (David Jarvis, )
         Re: Analysis Function  (Magnus Hagander, )
          Re: Analysis Function  (Tom Lane, )
           Re: Analysis Function  (Magnus Hagander, )
            Re: Analysis Function  (Tom Lane, )
             Re: Analysis Function  (Magnus Hagander, )
        Re: Analysis Function  (Tom Lane, )
         Re: Analysis Function  (David Jarvis, )
          Re: Analysis Function  (Magnus Hagander, )
           Re: Analysis Function  (David Jarvis, )
           Re: Analysis Function  (Tom Lane, )
            Re: Analysis Function  (Magnus Hagander, )
             Re: Analysis Function  (David Jarvis, )
              Re: Analysis Function  (Tom Lane, )
               Re: Analysis Function  (Bruce Momjian, )
 Re: Analysis Function  (Tim Landscheidt, )
 Re: Query about index usage  (Jayadevan M, )
  Re: Query about index usage  (Greg Smith, )
   Re: Query about index usage  (Jayadevan M, )

Magnus Hagander <> writes:
> On Sun, Jun 13, 2010 at 17:42, Tom Lane <> 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


В списке pgsql-performance по дате сообщения:

От: David Jarvis
Дата:
Сообщение: Re: Analysis Function
От: Kenichiro Tanaka
Дата:
Сообщение: Re: out of memory