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)
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
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
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
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
Ricardo Malafaia wrote:
> On 9/15/06, Douglas McNaught <[EMAIL PROTECTED]> wrote:
> >> What happens then when it sees something like a double variable
> >> interpolation as in $$foobar? ;)
> >
> >Then you use $FOO$ (or something else that doesn't appear in your
> >code) as the delimiter--you're not
Ricardo Malafaia wrote:
And the $$ is indeed needed for allowing languages with different
syntaxes. agreed. However, Tom, i could counter example your plperl
example:
realize that qq/end/ does not represent a matching "end"?
What happens then when it sees something like a double variable
i
On 9/15/06, Douglas McNaught <[EMAIL PROTECTED]> wrote:
> What happens then when it sees something like a double variable
> interpolation as in $$foobar? ;)
Then you use $FOO$ (or something else that doesn't appear in your
code) as the delimiter--you're not limited to just $$.
clever. still,
"Ricardo Malafaia" <[EMAIL PROTECTED]> writes:
> What happens then when it sees something like a double variable
> interpolation as in $$foobar? ;)
Then you use $FOO$ (or something else that doesn't appear in your
code) as the delimiter--you're not limited to just $$.
-Doug
-- Forwarded message --
From: Ricardo Malafaia <[EMAIL PROTECTED]>
Date: Sep 15, 2006 1:28 PM
Subject: Re: [HACKERS] polite request about syntax
To: Tom Lane <[EMAIL PROTECTED]>
ok, guys. i guess i was a bit unfair. Timestamp is used everywhere
indeed, Oracle, Fireb
"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
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
> -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
>
>
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'
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
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"?!
"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
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
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"?! And what about
the whole
19 matches
Mail list logo