Re: [HACKERS] polite request about syntax

2006-09-20 Thread Andrew Dunstan
Jeremy Drake wrote: > On Tue, 19 Sep 2006, Alvaro Herrera wrote: > >> Jeremy Drake wrote: >> >> > I have found the same thing with the type "timestamp without time >> zone". >> > The verbosity of type names seems rather extreme. >> >> Then use simply "timestamptz" (with TZ) or "timestamp" (without)

Re: [HACKERS] polite request about syntax

2006-09-19 Thread Jeremy Drake
On Tue, 19 Sep 2006, Alvaro Herrera wrote: > Jeremy Drake wrote: > > > I have found the same thing with the type "timestamp without time zone". > > The verbosity of type names seems rather extreme. > > Then use simply "timestamptz" (with TZ) or "timestamp" (without). Didn't know about these, lear

Re: [HACKERS] polite request about syntax

2006-09-19 Thread Alvaro Herrera
Jeremy Drake wrote: > I have found the same thing with the type "timestamp without time zone". > The verbosity of type names seems rather extreme. Then use simply "timestamptz" (with TZ) or "timestamp" (without). -- Alvaro Herrerahttp://www.CommandPrompt.com/ Pos

Re: [HACKERS] polite request about syntax

2006-09-17 Thread Jim Nasby
On Sep 15, 2006, at 11:32 PM, Jeremy Drake wrote: When I was first dealing with postgres, I found it extremely annoying that I had to type out "double precision" rather than just "double" since every sane programming language (as well as Java) uses double. I eventually figured out that it wa

Re: [HACKERS] polite request about syntax

2006-09-15 Thread Jeremy Drake
On Fri, 15 Sep 2006, Dave Page wrote: > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > > Ricardo Malafaia > > Sent: 15 September 2006 16:35 > > To: Andrew Dunstan > > Cc: pgsql-hackers@postgresql.org

Re: [HACKERS] polite request about syntax

2006-09-15 Thread Tom Lane
"Ricardo Malafaia" <[EMAIL PROTECTED]> writes: > my complaint is that, like i said, "timestamp with time zone" is no > good substitute for a simple "datetime". Here, someone suggested a > CREATE DOMAIN to create an alias for it. Why isn't it provided there > out-of-the-box by default? So you hav

Re: [HACKERS] polite request about syntax

2006-09-15 Thread Andrew Dunstan
The only person in denial is you. Here's a hard lesson about open source: bitching gets you nothing. YOU are not going to be taken seriously while all you do is complain. And if you must complain, make sure the politeness is in the words, not just the subject. The only place timestamp is m

Re: [HACKERS] polite request about syntax

2006-09-15 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Ricardo Malafaia > Sent: 15 September 2006 16:35 > To: Andrew Dunstan > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] polite request about syntax > >

Re: [HACKERS] polite request about syntax

2006-09-15 Thread Martijn van Oosterhout
On Fri, Sep 15, 2006 at 12:35:03PM -0300, Ricardo Malafaia wrote: > On 9/15/06, Andrew Dunstan <[EMAIL PROTECTED]> wrote: > >Where is the mention of either of these on the CREATE FUNCTION page? > > http://www.postgresql.org/docs/8.1/interactive/sql-createfunction.html Err, in the example? So you'

Re: [HACKERS] polite request about syntax

2006-09-15 Thread Ricardo Malafaia
well, ain't that surprising to see so many open-source developers living in denial and sugestions to RTFM rather than actually coping wth the problem? are you to be taken seriously? As a C programmer, I'm in the same league as most of you guys, so while i can really contribute code and my talk i

Re: [HACKERS] polite request about syntax

2006-09-15 Thread Andrew Dunstan
Ricardo Malafaia wrote: I've send the comment below to the documentation page about CREATE FUNCTION, but it got (rightfully) rejected, since it doesn't really add up to the discussion and is more of a request about syntax. So, here it goes: Sorry, but "datetime" vs "timestamp with time zone"?!

Re: [HACKERS] polite request about syntax

2006-09-15 Thread Tom Lane
"Ricardo Malafaia" <[EMAIL PROTECTED]> writes: > Sorry, but "datetime" vs "timestamp with time zone"?! And what about > the whole function text between $$'s? Yes, better than the '' of some > time ago, since we don't have to put string literals in the function > text between 's! still... "ti

Re: [HACKERS] polite request about syntax

2006-09-15 Thread Joshua D. Drake
Please, take this as constructive criticism, since i'm a proud open-source supporter... i would gladly use PostgreSQL at work, clunkier syntax or not, but it's otherwise difficult to sell it to my Windows-minded coworkers... I would love to take this as constructive criticism, but you haven't