Skip site navigation (1) Skip section navigation (2)

Re: interval / interval -> double operator

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Andrew Hammond <andrew(dot)george(dot)hammond(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: interval / interval -> double operator
Date: 2007-05-30 02:47:00
Message-ID: 24438.1180493220@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Andrew Hammond escribi:
>> Which got me looking for "date_part". But that only seems to be in the
>> gram.y file, include/catalog/pg_proc.h and the test suite. The pg_proc.h
>> stuff looks pretty interesting, but to decipher it, I figured I need to read
>> up on SystemFuncName().

> That's where you got lost -- if you had looked at the pg_proc.h entries
> more carefully you would have seen that they point to other functions,

Yeah --- AFAIR SystemFuncName() is just a convenience function that
does the equivalent of plastering "pg_catalog." on the front of the
mentioned name, so that it can't be confused with any non-built-in
function.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2007-05-30 03:20:22
Subject: Re: TOAST usage setting
Previous:From: Bruce MomjianDate: 2007-05-30 02:20:27
Subject: Re: TOAST usage setting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group